Posted to microsoft.public.excel.programming

Edgar[_3_] Edgar[_3_] is offline

external usenet poster

Posts: 40

Offset Prob

Hi

I am trying to name the variable name1 by an offset of
range a1 by a1 rows and 1 column.

But the following codes not working can anyone help me?

TIa

Sub TestName()

drp = Range("A1")
name1 = Worksheets("control").Range(drp).Offset(drp, 1)
MsgBox (name)

End Sub

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
CSE Formula Prob	pdberger	Excel Worksheet Functions	4	February 16th 08 03:51 AM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul	RyGuy	Excel Worksheet Functions	2	September 28th 07 10:54 PM
vlookup prob with all #n/a's	Janis	Excel Discussion (Misc queries)	5	July 30th 07 10:26 PM
Macro Prob	Carl	Excel Worksheet Functions	3	August 28th 06 05:03 PM
Still have formula prob :o(	Libby	Excel Programming	5	December 11th 03 05:26 PM

All times are GMT +1. The time now is 10:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us