hi guys must be simple but when i try it on macro recorder it just tells me the cell i have pressed return to.
all i want is the code for
go to the next cell down directly underneath
thanks
hi guys must be simple but when i try it on macro recorder it just tells me the cell i have pressed return to.
all i want is the code for
go to the next cell down directly underneath
thanks
VBA Noob![]()
ActiveCell.Offset(1, 0).Select
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
cheers vba
tried to intergrate that with the calendar but its not having it
any ideas?
when i click the date i want
i want it to insert that date in cell d24 and then go down to cell d25
My code does that so you can use that or wait for Roy to post.
VBA Noob
How are you using it?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
How is it 'not having it'?
Erroring? Not doing what you want it to?
Might be helpful to see some code and/or a workbook attachment.
Roy/Norie,
Relates to this thread
http://www.excelforum.com/excel-prog...-up-query.html
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks