Posted to microsoft.public.excel.programming

Mike

external usenet poster

Posts: 102

How does .offset(i, counter) work?

Hi everypne,

How does the following piece of code work:

With Range("G2")
For i = 1 To 30
.Offset(i, ModelCounter) = Range("Picked").Cells(i)
Next
End With

In particular the offset line please!

Thanks,
Mike

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
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul	RyGuy	Excel Worksheet Functions	2	September 28th 07 10:54 PM
activecell.offset does not work	hans[_3_]	Excel Programming	7	November 21st 04 06:53 AM
Trouble getting the OFFSET fo work	JimP	Excel Programming	7	July 29th 04 01:49 PM
Counter	JonoB[_4_]	Excel Programming	4	May 6th 04 12:19 PM
Counter	Larry Hau	Excel Programming	1	August 14th 03 11:00 PM

All times are GMT +1. The time now is 09:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us