last record

  1. B

    VBA to check each worksheet for ending row, if final row is x...

    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...
  2. T

    Last Row Finder problems

    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...
  3. D

    Conditional Formatting - Last Record

    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...

Some videos you may like

This Week's Hot Topics

Top