Lamar in Houston
Board Regular
- Joined
- Jan 21, 2006
- Messages
- 72
I have a worksheet which contains varying rows of data from day to day. I need to automate a way for a user to collect the data from all cells in two non-contigous columns, those being B and Y, from row 3 to the last record in those columns.
Below is the track I am on, one that I cannot make work with columns that are non adjacent.
Range (("B3:" & Range("B65536").End(xlUp).Address)), _
(("Y3:" & Range("Y65536").End(xlUp).Address))
Any suggestions?
Thanks
Below is the track I am on, one that I cannot make work with columns that are non adjacent.
Range (("B3:" & Range("B65536").End(xlUp).Address)), _
(("Y3:" & Range("Y65536").End(xlUp).Address))
Any suggestions?
Thanks