refering to a range with a variable

Posted to microsoft.public.excel.programming

eyecalibrate[_2_] eyecalibrate[_2_] is offline

external usenet poster

Posts: 1

refering to a range with a variable

I'm looking for a way to refer to a range with a variable. Let me
demonstrate.

Dim MyVar
MyVar = ActiveCell.Value
Range("A14").Select

I've tried this:

Dim MyVar
MyVar = ActiveCell.Value
Range("A(MyVar)").Select

But (of course) it doesn't work; however this is essentially what I
need.

How can I make this happen?

---
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
Can you name a worksheet by refering to a cell reference or range	o2bing	Excel Discussion (Misc queries)	10	March 21st 08 07:18 AM
Refering to a named range in a chart: 2007	fruitticher	Excel Worksheet Functions	1	September 14th 07 06:52 PM
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table	Conan Kelly	Excel Worksheet Functions	6	April 11th 07 12:32 AM
Change the Range refering to a Name	TonTon165	Excel Discussion (Misc queries)	2	June 27th 06 03:28 PM
Simple problem refering to variable in For ... Next loop ...	Chris	Excel Programming	1	July 15th 03 01:00 AM

All times are GMT +1. The time now is 11:15 AM.

Menu

About Us