How can I make this work?:

Cells(17, ProcessRow).Resize(19).Select & Cells(41, ProcessRow).Resize(43).
Select

I am trying to select 2 groups of cells so I can run a search within them.
Can this be done?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

i used 1 instead of processrow, because i didn't know what it referred to

Sub test()
Union((Cells(17, 1).Resize(19)), Cells(41, 1).Resize(43)).Select
End Sub

--


Gary


"erikkeith via OfficeKB.com" <u13156@uwe wrote in message
news:6a0026897afe6@uwe...
How can I make this work?:

Cells(17, ProcessRow).Resize(19).Select & Cells(41, ProcessRow).Resize(43).
Select

I am trying to select 2 groups of cells so I can run a search within them.
Can this be done?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1