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

Please Login or Register  to view this content.

**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