Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Medium Priority · Version 2003
Reply Fri 15 May 2009, 16:34Delegate Sotirios said...
Sotirios has attended:
Excel VBA Intro Intermediate course
VBA
if you are using an input box to capture data how do you reference the entry to the next available cell available in a worksheet.
For upcoming training course dates see: Pricing & availability
RE: VBA
Hi Sotirios
Thank you for your question
I am assuming that you have a list and you wish to find the next blank row. Assuming that cell A1 is within the list then the following will allow you to identify the last row.
intVariable = range("A1").currentregion. rows.count+1
You can then reference that row/cell with
cells(intvariable,1) = value
Hope this is useful
regards
Stephen
Reply Mon 18 May 2009, 21:27Delegate Sotirios said...
RE: VBA
thanks this is very useful. when this finds that cell entering data is quite simple but I have got stuck trying to compare that value to the last entry - that must always be one more than the previous one.
|