-
I use Excel 2000 under Windows XP. The maximum number of columns seems to be 230 (A-IV). Is there any way to increase the number of columns? I am using the transpose option when pasting ~700 rows, and it is a real pain to have to do it in 4 pieces, and of course, greatly increases the likelihood of making...
-
Jim I doubt this is the full extent of your issue, but using you example... Sub TransposeRng() Range( "A1:E1" ).Value = Range( "A1:A5" ).Value Range( "A2:A5" ).Clear End Sub Post back when you want this done for many columns