A
april
i have a macro which finds the last row and returns the value Last Row. i
want to use this info to auto fill a range - Selection.AutoFill
Destination:=Range("B10:B & LastRow"). I get an error message when i try
this. should i name the variable LastRow at the beginning of the macro? or
is there something wrong with the placement of the quote marks?
thanks in advance for your help
want to use this info to auto fill a range - Selection.AutoFill
Destination:=Range("B10:B & LastRow"). I get an error message when i try
this. should i name the variable LastRow at the beginning of the macro? or
is there something wrong with the placement of the quote marks?
thanks in advance for your help