In attempting to write an VBA marco in excel, both of the two pieces of code below return
Run-time error ‘1004’:
Method “Range” of object “_Global” failed
With the second line of code highlighted.
First attempt
Second attempt
I have "dim'ed" finalrow as an integer. What am I doing wrong?
Run-time error ‘1004’:
Method “Range” of object “_Global” failed
With the second line of code highlighted.
First attempt
Code:
finalrow = Range("G65536").End(xlUp).Row
Range("H & finalrow").Select
Second attempt
Code:
finalrow = Range("G65536").End(xlUp).Row
Range("H” & “finalrow").Select
I have "dim'ed" finalrow as an integer. What am I doing wrong?