cell set as range not recognized

ThomasOES

Board Regular
Joined
Aug 29, 2017
Messages
116
I've set cell as a range, yet getting error when selecting range

Code:
[FONT=Verdana]onedeg = Range("currel").Offset(13 + m)
onecon = Range("currel").Offset(13 + m, 1)[/FONT]
[FONT=Verdana]Range(onedeg, onecon).Select[/FONT]
Why wont this work?

Thanks
Tom
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,685
Office Version
365
Platform
Windows
You haven't Set the range ;)

I.e.
Rich (BB code):
    Set onedeg = ...
    Set onecon = ...
 

Forum statistics

Threads
1,077,674
Messages
5,335,605
Members
399,028
Latest member
greyland

Some videos you may like

This Week's Hot Topics

Top