M
Matt Houston
Hi there
I am trying to use a macro to format a spreadsheet. I have a column o
numbers, in the next column I need to put the same text next to eac
number/row, so I put the text in the first cell of the next column an
used autofill. This works fine except that when I look at the VBA i
has used this bit of code -> Selection.AutoFil
Destination:=ActiveCell.Range("A1:A761"), in other words it will fill
set number of cells and if my list of numbers is any shorter/longer th
next time I want to use the macro it will cause problems. Any ideas o
how I can get around this?
thank
I am trying to use a macro to format a spreadsheet. I have a column o
numbers, in the next column I need to put the same text next to eac
number/row, so I put the text in the first cell of the next column an
used autofill. This works fine except that when I look at the VBA i
has used this bit of code -> Selection.AutoFil
Destination:=ActiveCell.Range("A1:A761"), in other words it will fill
set number of cells and if my list of numbers is any shorter/longer th
next time I want to use the macro it will cause problems. Any ideas o
how I can get around this?
thank