PDA

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.