I need to set a range based on 4 variable which represent two columns o
records. I would like something similar to below but this code doe
not function properly. How can I define two ranges within one range?

Eg. Range(Cells(3,3)
Cells(numrow,3):Cells(3,5),Cells(numrow,3)).Select

How do I define this?
Thanks

--
Message posted from http://www.ExcelForum.com