Move SUBTOTAL cells - ExcelBanter

Posted to microsoft.public.excel.programming

MikeF[_2_] MikeF[_2_] is offline

external usenet poster

Posts: 173

Move SUBTOTAL cells

Have come across a situation where, for presentation purposes the SUBTOTAL
rows need to be moved one cell to the right.
Have been struggling with the following but need some assistance, which will
be greatly appreciated.
Regards,
- Mike

For Each c In Range("b2:b100")
If InStr((c.Value), "Total") Then
c.Cut Destination:=ActiveCell.Offset(0, 1)

End If
Next

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
CountA, Subtotal and "move to the first cell in the next column"	LongBeachGuy	Excel Programming	4	October 17th 07 02:59 AM
CountA, Subtotal and "move to the first cell in the next column"	LongBeachGuy	Excel Discussion (Misc queries)	1	October 16th 07 10:57 PM
CountA, Subtotal and "move to the first cell in the next column"	LongBeachGuy	Excel Programming	0	October 16th 07 10:29 PM
move to another cell within a subtotal report within a macro	NoelH	Excel Worksheet Functions	1	August 31st 05 03:02 PM
HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE	BEACHGRANDPA	Excel Worksheet Functions	0	August 24th 05 04:46 PM

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

Menu

About Us