LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default Go to cell 65000

I have a macro where I do a lot of things, but I require to go to 65,000 of
the original column -- which is not predicatable. Whatever the active cell
the next 2000 rows have their font turned white. However, I don't always have
2000 rows and I need to delete all the extra rows so that extra pages are not
printed.

'The column of active cell
Dim OrigCol as Range
OrigCol=ActiveCell.Column
' Code from recorded macro -- leaves me at the last cell -- which is not
predictable

I would now like to get to row 65000 of the Original Column

Please help!!

 
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
Working with more than 65000 rows in Excel Nainar Excel Discussion (Misc queries) 1 November 26th 07 03:20 PM
65000 limit Ven Excel Discussion (Misc queries) 4 October 26th 06 03:21 PM
Data contains more than 65000 rows ? turrucan Excel Worksheet Functions 7 August 31st 06 07:08 AM
How to get more than 65000 rows in and excel spreadsheet Jake Clark Excel Discussion (Misc queries) 3 October 25th 05 12:49 PM
How can i handle more than 65000 rows in excel psk[_6_] Excel Programming 3 November 2nd 04 11:03 AM


All times are GMT +1. The time now is 02:53 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"