how to extend columns pass IV
 

*hi! i'm new here and i need help on how to extend the columns in excel
normal extendsion is A to IV but i was wondering if u could extend the
columns beyond that using vbas and marcos?
if some one would please tell me it'd be great :)
thanks a lot*


--
freakyboy88
------------------------------------------------------------------------
freakyboy88's Profile: http://www.excelforum.com/member.php...o&userid=25074
View this thread: http://www.excelforum.com/showthread...hreadid=385907

how to extend columns pass IV
 

The answer is NO. Here's a couple workarounds:
--put the data vertically so you don't need so many columns
--combine some of the columns, like last name and first name or some other
columns that make sense when combined
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"freakyboy88"
wrote in message
...

*hi! i'm new here and i need help on how to extend the columns in excel
normal extendsion is A to IV but i was wondering if u could extend the
columns beyond that using vbas and marcos?
if some one would please tell me it'd be great :)
thanks a lot*


--
freakyboy88
------------------------------------------------------------------------
freakyboy88's Profile:
http://www.excelforum.com/member.php...o&userid=25074
View this thread: http://www.excelforum.com/showthread...hreadid=385907

how to extend columns pass IV
 

No you can't. XL (all versions) is limited to 256 columns.

You *can* use multiple sheets. You can also, if you have less than 256
rows of data, transpose it to use rows instead of columns...


In article ,
freakyboy88
wrote:

*hi! i'm new here and i need help on how to extend the columns in excel
normal extendsion is A to IV but i was wondering if u could extend the
columns beyond that using vbas and marcos?
if some one would please tell me it'd be great