#10

Posted to microsoft.public.excel.worksheet.functions

joeu2004

external usenet poster

Posts: 2,059

VBA range selection question

On May 8, 11:27*am, joeu2004 wrote:
One way:
GetColNum = Range(myColumn & 1).Column

Another way:

GetColNum = Cells(1, myColumn).Column

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
Filter and selection question	tjcmills	Excel Discussion (Misc queries)	1	April 2nd 09 11:59 AM
Narrow Range based on Selection in Another Range	David	Excel Discussion (Misc queries)	3	July 1st 07 05:12 PM
Identifying a selection of a selection of a range	swimfast	Excel Worksheet Functions	1	March 1st 07 02:51 AM
Range Selection	cfspahn24	Excel Discussion (Misc queries)	3	April 14th 06 01:29 PM
A cell selection question	jezzica85	Excel Discussion (Misc queries)	1	April 8th 06 12:40 AM

All times are GMT +1. The time now is 02:01 AM.

About Us

"It's about Microsoft Excel"