Set a Range to all of the first row

Posted to microsoft.public.excel.programming

Kevin McCartney[_2_] Kevin McCartney[_2_] is offline

external usenet poster

Posts: 32

Set a Range to all of the first row

I'd like to do two things, set a range to all of row one
and set a second range to all of column A

Please help with the correct code to use. currently I have

Set rgeSearch1 = Application.Worksheets(Z).column(1)
Set rgeSearch1 = Application.Worksheets(Z).rows(1)

Thanks

Best regards
KM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I enter formula sum(range+range)*0.15 sumif(range=3)	tkw	Excel Discussion (Misc queries)	2	October 1st 09 09:17 PM
Excel Addin:Setting the range to the Excel.Range object range prop	Rp007	Excel Worksheet Functions	5	November 24th 06 04:30 PM
Selecting range in list of range names depending on a cell informa	Courreges	Excel Discussion (Misc queries)	2	June 19th 06 10:59 AM
formula to sort a range so that it matches the exact rows of a column that is outside that range?	steveo	Excel Discussion (Misc queries)	1	June 18th 06 02:05 AM
how to? set my range= my UDF argument (range vs. value in range) [advanced?]	Keith R[_3_]	Excel Programming	2	August 11th 03 05:55 PM

All times are GMT +1. The time now is 05:22 PM.

Menu

About Us