Next Available line in table

[BSando]

Hi all

I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet.
This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered in the next line of the table. I have not created the form yet. I am trying to understand how I can do it first.
So for example my table is on sheet 3 and looks like the below
Name Number Address Suburb State Postcode Phonenumber


Any Help would be appreciated.

Thanks in Advance


Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[SkipVought]

Hi,

Check out the CurrentRegion property...

lNextRow = Sheet3.[A1].CurrentRegion.Rows.Count + 1

assuming that your heading starts in A1.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[BSando]

Skip,

Thanks for your help

Some people make things happen, some watch while things happen, and some wonder 'What happened?'