Finding next empty row in another worksheet

[spyrule]

Hello,

ok, this is probably a simply solution, that for whatever dumb reason is
elluding me.

I have a simple excel document. It's a workplace attendance tracking excel
document. Nothing complicated.

WS NAMES
WS1 = "input" (This is where the input for all agents information is entered)
WS2-8 = "agent name" (this is essentially a near copy of the input, but
only stores the data on that agent ).

WS1 has 8 simple buttons, and 6 checkbox's. Each checkbox corresponds to a row of input data (so max being copied to destination, is 6 rows of 9 columns of data).

Here's what I want to happen, input the data, and click the agent name.
The button command, will determine the appropriate destination worksheet (allready have this working), FIND THE NEXT BLANK ROW between ranges
A5 and A54, Then copy the files from checkmarked selected source (WS1), to the destination blank row.

The problem I am having is how to find the next blank ROW and set a variable with the row number.

here is the code I have so far :

Please Login or Register  to view this content.

Any help is apreciated,

Spyrule

[Bryan Hessey]

Hello,

ok, this is probably a simply solution, that for whatever dumb reason is
elluding me.

The problem I am having is how to find the next blank ROW and set a variable with the row number.

Spyrule

something like

LastIRow = Sheets("Inspections").Range("A65536").End(xlUp).Row

---

[spyrule]

Hey,

Wanted to say thank you, as that seems to have done the trick.

Here is the final code for that function :

Please Login or Register  to view this content.

Thanks again,

Spyrule