Posted to microsoft.public.excel.programming

Bob Zimski Bob Zimski is offline

external usenet poster

Posts: 30

Range referencing incorrectly

I seem to be missing how to reference celles properly, any help appreciated:

Dim i As Integer
For i = maxrows To 2 Step -1
Range("cells(i,1):cells(i,2)").Select
Selection.Cut Destination:=Range("cells(i-1,3):cells(i-1,4)")
Next i

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
Referencing a named range based upon Range name entry in cell	Barb Reinhardt	Excel Worksheet Functions	14	June 20th 07 07:19 PM
Incorrectly getting "Subscript out of range" Error.	Andrew[_55_]	Excel Programming	4	April 30th 07 08:45 AM
range referencing	lakey13[_5_]	Excel Programming	1	November 9th 04 04:03 PM
range referencing	lakey13[_4_]	Excel Programming	0	November 9th 04 03:38 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us