Hi,
For some reason I get very different results when I run the following :
Range("C3").End(xlToRight).Select
Will take me to the correct cell that I want at the end of the data !
LastColumn = Range("C3").End(xlToRight).Select
When I run this as part of a macro it returns a value of -1
LastColumn is Dim'd as Long
Any ideas ?
For some reason I get very different results when I run the following :
Range("C3").End(xlToRight).Select
Will take me to the correct cell that I want at the end of the data !
LastColumn = Range("C3").End(xlToRight).Select
When I run this as part of a macro it returns a value of -1
LastColumn is Dim'd as Long
Any ideas ?