last active cell of sheet

There are a few standard ways to find the area containing data in a worksheet, but each has a problem. 1) Activesheet.Cells(1).CurrentRegion won't work correctly if there are blank rows or columns 2) Activesheet.Cells(Activesheet.Rows.Count, 1).End(xlUp).Row won't work correctly if there is...

Hi Any help with VBA on this would be appreciated.:confused: I have a workbook, z:\promotional and marketing\product performance\weekly data\cacs.xls which I download each week. Firstly, I need to Copy cells A2 : last active cell in column R I then need to Paste Values into z:\promotional and...

Sheets(1).Copy Before:=Workbooks( _ "TESTING232.xlsm").Sheets(Sheets.Count).Offset(1) I am copying the first tab of workbook 1, and trying to paste into workbook 2's last sheet. I got something like that, but can't figure it out how to set up the last page. Is there any way to set up...

I have a report that is ran once a month and each sheet in the report has a variable number of rows each month. I have used the macro recorder to subtotal each sheet, but on sheets with more rows, the code does not include them in subtotal. I have tried using an offset but that didn't work...

Hi Genius People, I have the below code running for a sheet where I am collating data from various sheets. The macro is running fine but the problems comes when it is pasting the values in the master sheet, where the last rows of the data are empty. Like in the below table the macro will...