M
MIndy
I am trying to zero fill columns in a spreadsheet for a thrid party vendor to
import into their system. These need to be 'front filled'.
import into their system. These need to be 'front filled'.
S
sebastienm
using a macro? If so:
Say you want to zero-ed cells A1:B100 and D1
100 of the active sheet
Dim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1100").Value = 0
Regards,
Sebastien
Say you want to zero-ed cells A1:B100 and D1
100 of the active sheetDim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1
100").Value = 0Regards,
Sebastien
S
sebastienm
sorry , i meant:
Dim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1100")
Rg.Value = 0
Dim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1
100")Rg.Value = 0