Search results

  1. B

    VBA to Find First Empty Cell in a Row and Insert Text

    I do have the other objects referenced. Below is the working code prior to me trying to find the last cell and insert the text: Function ExportPMC() 'Exports both the 'Today's Prices and Rates - Output' table to an Excel spreadsheet titled 'Prices and Rates - MM-DD-YYYY.xlsx' using the...
  2. B

    VBA to Find First Empty Cell in a Row and Insert Text

    Thanks. I'll try that for that piece, but I should have mentioned that it first error's out when trying to find the first blank cell. I've tried many variations of the following: xlSheet.Range("A" & rows.Count).end(xlup).offset(1, 0) Tried defining it as an object: Dim xlBlankCell As...
  3. B

    VBA to Find First Empty Cell in a Row and Insert Text

    Hello - Hoping someone can help me with my translation of Excel VBA to Access. I'm using Access to export the results of a query to Excel and within the same code I am opening up the spreadsheet to format it. Part of the formatting requires me to find the first empty cell in column A, and...
Back
Top Bottom