last record

I am looking for code to check each worksheet in the active workbook for ending row number, if final row is x and last cell contains phone number continue, otherwise pause and allow worksheet correction. When corrected, continue through last worksheet. I have no idea where to even start on this...

I have a set of code working but it can only copy a column at a time, as shown below: x = Range("A" & Rows.Count).End(xlUp).Row x = x + 1 Sheets("CSV").Range("B" & x).Copy Sheets("Sheet1").Activate Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False So i was wondering if the...

Hello, I am wondering if there is an easy way to conditionally format the last record in my spreadsheet. Seems simple enough but there is a catch: my dilemna is that the location or row of the last record might change (i.e. row 35 one day and row 39 the next). I created a PivotTable using Excel...