LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 151
Default Forcing xl2K7 Column Count back to xl2K3 size

Hi all

Well it seems I took the long-winded scenic route on this one.

I managed a workaround for it, so instead of this:

If copyLine = True Then
Rows(i & ":" & i).Select
Selection.Cut

I changed it to this:

If copyLine = True Then
Range(Cells(i, 1),Cells(i, 256)).Select
Selection.Cut

And it work well..

Cheers
Mick.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forcing a certain date format in an Excel column angela Excel Programming 1 January 26th 07 02:46 AM
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM
Formula bar height in XL2K3 w/XP Jon Bouy Excel Discussion (Misc queries) 8 February 24th 05 02:09 AM
Can we write VBA code to set all column/row's size back to default size? Charles Williams Excel Programming 0 July 8th 03 03:56 PM
Can we write VBA code to set all column/row's size back to default size? Earle Excel Programming 0 July 8th 03 02:46 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"