Dear All,
I am trying to set the last row of data to a variable LastRow, which I have used many times before successfully! However, it just doesn't want to work on my current Macro and I get a compile error?
(Compile Error: Variable not defined)
(Has this beginner obviously missed something or inadvertantly flagged someing to hinder his progress?) Code to follow!
Any thoughts?
javascript:emoticon('')
Bang head
Many thanks!
Dean
[/i]
I am trying to set the last row of data to a variable LastRow, which I have used many times before successfully! However, it just doesn't want to work on my current Macro and I get a compile error?
(Compile Error: Variable not defined)
(Has this beginner obviously missed something or inadvertantly flagged someing to hinder his progress?) Code to follow!
Code:
Range("A17").Select
ActiveCell.End(xlDown).Select
LastRow = Selection.Row
Any thoughts?
javascript:emoticon('')
Bang head
Many thanks!
Dean
[/i]