Prev Previous Post   Next Post Next
  #1   Report Post  
DME
 
Posts: n/a
Default Macro Help

I need to run a Macro(set up a command button) that will take me to the next
open box in a specific column. For instance if I have data in Cells C5 to
C11. I want to run a macro to select cell C12.

I have tried but not being very successful.

I currently have a macro that is setup to run a macro from the cell I am on
(user has to select C12 currently). I want to be able the user to just run
the macro by pressing the command button rather than having to going to cell
c12 then running the macro. In essence, make the process dummy proof. I
have users currently who cannot seem to select the next open cell in the
correct column.

My boss thinks this is impossible, but I told him all I have to do is post
the question out here. This group has made me look like a genius on more
than one ocassion. Thanks!




 
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
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Macro Formula revision? Mark Excel Worksheet Functions 1 November 28th 04 01:43 AM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


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