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: 98
Default Advancing to the next cell

Hello all,

Is there a method (like the .SaveAs method) to advance the active cell to
the next unlocked cell? If so, when the active cell is in the last column
of unlocked cells for that row, will it advance to the first column of
unlocked cells for the next row?

I am hoping that there is a method that can be used. I can figure it out
using Range() or Cells() and doing a little math. But to use this way would
take some extra work like some rearanging of my worksheet.

Thanks for any help anyone can provide,

Conan Kelly



 
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
Excel automaticly advancing copied cell numbers Amazon H. Excel Worksheet Functions 5 August 18th 07 05:01 AM
Excel automaticly advancing copied cell numbers Max Excel Worksheet Functions 1 August 17th 07 01:54 AM
Advancing from Cell to Cell on Key Press Lee C[_2_] Excel Programming 1 June 13th 05 10:48 PM
Copy Cell or Column without advancing formula reference? sgluntz Excel Discussion (Misc queries) 1 March 17th 05 07:13 PM
automatic cell advancing Marc Excel Programming 1 October 28th 04 03:21 PM


All times are GMT +1. The time now is 12:14 AM.

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"