Select Last Used Cell for VBA Range

I am using VBA in excel to send Outlook Meeting Requests. The coding works perfectly for sending the requests, so there are no issues with the actual macro.

My issue is directing the macro to select the last edited cell in Columns B, C, D, etc to prefill the meeting request. Currently I'm just copying the last edited cells to B1, C1, D1, E1, and F1, but I wish I could just direct the program to look at the bottom of the spreadsheet.

The code is as follows:

Please Login or Register  to view this content.

Hello stevedes7,

Do you really mean the last whose data has changed or the last in the column with data?

Hey Leith,

Last row of data in the column.

Or to be more specific, each cell in the last row of data. In this scenario, the last row of data is in Row 500. In this case, B500, C500, D500, E500, F500, etc are used.

Is this what you mean?

Please Login or Register  to view this content.

Note your code will only work if the data sheet is active

Hello stevedes7,

This version of the macro looks only at columns "B" to "G" and finds the last cell in these columns only.

Please Login or Register  to view this content.