How to resize range, to adjust number of columns?

**Flowerski** · 05-29-2012, 03:59 PM

Hi
THe resize method is used to change number or rows. How to resize a range to change only the quantity of columns. I know where the range starts (startpoint) and I know exact number of columns needed. Number of columns is a variable. Please suggest something. Thanks

**tom1977** · 05-29-2012, 04:03 PM

Hi
Check this

Sub bb()
Dim x As Long
x = 8
Cells(1, 1).Resize(, x).Select
End Sub

**Flowerski** · 05-29-2012, 04:25 PM

Tom thanks, it was a kindergarten solution. I thought thaat resize changes only number of rows. THanks, by the way I am Polish too. Dzieki, ja zaczalem uzywac tego forum dzisiaj poraz pierwszy i jeszcze nie rozumiem dokladnie jak tu wszystko jest zorganizowane. Na przyklad nie wiem o jaka small star icon Ci chodzi. Please explain. Jeszcze raz dzieki. Troche mi wstyd bo o resize to ja powinienem wiedziec. Thanks anyway
Radek