View Full Version : Solved: Insert columns based on a variable
Aussiebear
12-09-2011, 12:16 AM
How do I insert a number of columns, starting at column C, based on a variable located in cell G13?
mancubus
12-09-2011, 01:38 AM
perhaps
Sub InsertMultiCol()
Dim insCol As Long
insCol = Range("G13").Value
Range("C1").Resize(, insCol).EntireColumn.Insert
End Sub
Aussiebear
12-09-2011, 02:39 PM
Thank you
mancubus
12-10-2011, 02:28 AM
you're most wellcome.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.