As the title would suggest I want to return the value of the last used row of data in column 'A', I know that I can use something like
LastRow = ActiveSheet.UsedRange.Rows.Count
But the tricky part is that I want the code to ignore any cell which contains a formula.
Anyone know how to do...