Shifting of Multiple Row to the right

Posts: n/a

macro

Hi can anyone help me with my problem?
Thanks in advance!

I had receive a compile data from one of my vendors and there is one
adjustment i need to make in order to alight with correct heading column. The
macro i had try to create doesn't really works. Cause it works only on one
selected rows.

Range("A752:H752").Select
Selection.Cut
Range("B752").Select
ActiveSheet.Paste

I need to amend about twenty thousand of selected rows in order to work on
the data.

Thx & regards
William

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
Make Alignment options under format cells available as shortcut	dforrest	Excel Discussion (Misc queries)	1	July 14th 05 10:58 PM
Help with macro looping and color query function	kevinm	Excel Discussion (Misc queries)	10	May 26th 05 01:25 AM
Playing a macro from another workbook	Jim	Excel Discussion (Misc queries)	1	February 23rd 05 10:12 PM
Date macro	Hiking	Excel Discussion (Misc queries)	9	February 3rd 05 12:40 AM
Macro and If Statement	SATB	Excel Discussion (Misc queries)	2	December 3rd 04 04:46 PM

All times are GMT +1. The time now is 07:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us