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: 1
Default Macro - Selecting Next Available Cell


I posted this in the new users forum but figured it would probably best
be answered here.

I am trying to design a macro to work with a database I made in excel.
I have a lot of questions since I have never made a macro before. But
I'll just start with a simple question. I want to run a macro that will
input the current date in cell a1, then when I run the macro the next
day, I want to input the current date in cell a2. How do I set up a
macro to do that? I tried setting up a counter but I don't know how to
say something like Range(a1 + 1) = Now. So it selects the next cell
down everytime I run it. Thanks for the help in advance.

Jason


--
cappuccine
------------------------------------------------------------------------
cappuccine's Profile: http://www.excelforum.com/member.php...o&userid=28242
View this thread: http://www.excelforum.com/showthread...hreadid=482006

 
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
Macro Pause for selecting cell jo2109 Excel Discussion (Misc queries) 3 June 4th 09 02:05 AM
macro selecting row that cursor is on (not the same cell every tim Jeremy Excel Discussion (Misc queries) 8 May 19th 08 05:09 PM
Help for Macro: Finding last cell and selecting it [email protected] Excel Discussion (Misc queries) 4 January 29th 07 08:40 AM
Macro selecting wrong cell range Josh[_10_] Excel Programming 1 June 23rd 04 06:48 PM
Macro selecting the last used cell does not work Kaj Pedersen Excel Programming 1 November 4th 03 10:25 PM


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