Joseph McGowan
New Member
- Joined
- Mar 24, 2002
- Messages
- 11
If I have a macro button on a sheet and when this is clicked I would like column B of the next blank row selected for user input and in column A I would like the Date to appear.
What code do I use for this to happen.
I am trying something like
intLastRow = Sheets("New Joins").Cells(65000, 1).End(xlUp).Row
New Joins is the name of the worksheet.
It is not selecting the correct cell.
Can anyone help me please.
I have not worked out how to do the date part.
What code do I use for this to happen.
I am trying something like
intLastRow = Sheets("New Joins").Cells(65000, 1).End(xlUp).Row
New Joins is the name of the worksheet.
It is not selecting the correct cell.
Can anyone help me please.
I have not worked out how to do the date part.