Posted to microsoft.public.excel.programming

Mikeymay

external usenet poster

Posts: 5

Declaring a Range

Within a macro I want use the offset command and then return to a cell.

I have declared the variable CurrCell as Range

then

Set CurrCell = Range(Activecell)

and then I want to be able to return to CurrCell after offsetting around the
worksheet.

Any ideas?

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
Declaring a Range Object	pooja[_2_]	Excel Programming	13	May 24th 04 04:58 PM
Declaring Variables	Brad	Excel Programming	3	May 12th 04 08:13 PM
declaring a msgbox	Tracey[_6_]	Excel Programming	2	May 12th 04 04:43 PM
Declaring a DLL	Erich Neuwirth	Excel Programming	1	May 10th 04 06:27 PM
DEclaring variables	Pedro	Excel Programming	2	November 13th 03 11:54 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us