Insert 10 columns staring at K50?

B

Bret1

Board Regular
Joined
Jun 14, 2013
Messages
199
Hi,
Can you please tell me the macro used to add 10 columns at K starting at row 50?

Basically, I want to move all data from k50 and below, over 10 columns to the right, without moving the data above k50.

Thanks!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
How about
Code: 
Sub Bret1()
   Range("K50", Range("K" & Rows.Count).End(xlUp)).Resize(, 10).Insert xlToRight
End Sub
 
Upvote 0
Can you also tell me how to change the line below to only select below row 50 on column AG?
Set sourceColumn = Columns("AG:AG")
 
Upvote 0
Like
Code: 
Set Source= Range("AG50", Range("AG" & Rows.Count).End(xlUp))
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
VBA for Cut, move, paste, delete rows
Replies
6
Views
161
RForster6
R
R
  • Solved
Preparing spreadsheet for mail merge
Replies
3
Views
61
mumps
mumps
R
  • Solved
VBA moving rows
2
Replies
14
Views
969
Joe4
Joe4
T
  • Solved
Move cursor to a specific cell after data has been entered
Replies
4
Views
220
Peter_SSs
Peter_SSs
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
275
sijpie
sijpie

Forum statistics

Threads
1,223,931
Messages
6,175,465
Members
452,646
Latest member
tudou

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top