Posted to microsoft.public.excel.programming

Blewyn[_6_] Blewyn[_6_] is offline

external usenet poster

Posts: 1

Selecting a row with a variable ?

How do I select an entire row by using a variable to store the row
number ? I currently have a statement which selects a range :

Range(Cells(Count, 1), Cells(Count, 16)).Select

but I'd like to select the entire row (row number is Count) instead...

Any ideas ?

Thanks,

Blewyn

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

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
Selecting a variable print area in a macro	Surrealest	Excel Discussion (Misc queries)	2	June 7th 09 07:08 AM
Selecting Variable Data Ranges	rc	Excel Discussion (Misc queries)	2	May 18th 07 08:26 PM
Selecting Variable Row Range w/Macro	steve	Excel Programming	3	February 26th 04 07:24 PM
Selecting rows with variable	Jim[_24_]	Excel Programming	7	September 16th 03 02:03 PM
Selecting a Range Using a Variable	Bob J.	Excel Programming	4	September 14th 03 09:24 PM

All times are GMT +1. The time now is 12:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us