No. of Rows determination to place formula in new col

[sdsmithinc]

Greetings,
I have a conundrum to solve and since my knowledge is lower than a dead elephant (yea, I'm a newbie) I need some help. I would like through VBA determine the number of data filled rows in an active sheet, use that number to place a set formula at the end of each row in that sheet. The formula can change (as I add more col.s by running a similar script). Any ideas?
Thanks

[jaslake]

Hi sdsmithinc

Welcome to the Forum!!!

This will find the last row with Data in the Worksheet:

Please Login or Register  to view this content.

This will find the last column with Data in the Worksheet

Please Login or Register  to view this content.

This will find the first empty row in the Worksheet

Please Login or Register  to view this content.

[sdsmithinc]

Thanks for the reply but using the code(s) only partially solves my issue. The versions you have indicated only show a place marker. I would like to be able to place a predetermine formula at the end of each row that has data then use the same process to create another column with a different formula . So I was thinking I need to determine the number of rows and copy the formula at the end of each row. The formula just compares several cols in each row and creates a number which is used on another sheet. I can use VBA to copy the formula into one cell but I can't figure out how copy the same formula at the end of each row that has data. The work sheet can have any number of rows, does this codify what I'm asking for?

Range("A" & Rows.Count).End(xlUp).Row [this just errors out]
[Below is the how I can copy the formula (just for example), but how to copy multiple times at the end of the row
Range("K2").Select
ActiveCell.FormulaR1C1 = "=IF(R[-1]C[-10]=RC[-10],100,100)"
Range("K2").Select

[jaslake]

Hi sdsmithinc

Having found the

Please Login or Register  to view this content.

What's your Formula? You can write it to

Please Login or Register  to view this content.

Post a Sample File...perhaps I'll understand better and be able to help.

[sdsmithinc]

Edited post to indicate what if done or at least tried to do:

[jaslake]

Hi sdsmithinc

In your Sample File, which Columns would you like Totals?