VBA

Resolved · Medium Priority · Version 2003

Fri 15 May 2009, 16:34 Delegate 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.

Mon 18 May 2009, 09:02 Trainer Stephen said...

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

Mon 18 May 2009, 21:27 Delegate 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.

Training courses