union(Range(Cells(3,3),Cells(numRow,3)),Range(Cell s(3,5),Cells(numrow,3)))

Sure your cells are correct

Assume number is 6

Range("C3:C6,E3:C6")

perhaps

union(Range(Cells(3,3),Cells(numRow,3)),Range(Cell s(3,5),Cells(numrow,5)))

from the immediate window:
numrow = 6
?
union(Range(Cells(3,3),Cells(numRow,3)),Range(Cell s(3,5),Cells(numrow,5))).A
ddress
$C$3:$C$6,$E$3:$E$6

--
Regards,
Tom Ogilvy


"waveracerr " wrote in message
...
I need to set a range based on 4 variable which represent two columns of
records. I would like something similar to below but this code does
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/