last active row

Hello! I've searched for something similar to this and have not had much luck. I apologize if it is an easy(ier) answer and I am just missing it. I have a data set that I download, export, and format multi times weekly. The data set is 125 columns by usually around 45,000 rows. The number of...

Hi Excel gurus, I'm struggling to find a solution for this (via VBA), but is it possible to compare the last two cells in 2 columns for example, column A has 50 cells populate (A1-A50) however column B has 5 populated, is it possible to highlight this discrepancy? i.e the count of active cells...

I've been using VBA (and this message board) on and off for years. The majority of the time I find I don't need to post because somebody has already asked and answered the question; but this time I'm truly stumped. I tend to modularize the majority of my code to make troubleshooting easy and...

HI I need to copy the last value in the column every month and copy paste it into another document which shows the KPI for the current month. So if you look up the picture i need all the values from mar2021 to be copied this month and apr2021 next month. Is it possible to make some kind of VBA...

I am wanting this code to loop through various files in a folder and copy info from each file and paste to a master file - my issue is that after it opens the first file and moves on to the second one, it will paste the header in there as well. All data starts on the same cells "A5" in all the...

Hello Guys, I have workbook with Sheets 1 to 10. For each sheet, I need to find the last row, delete the excess vertical lines below it (just CTRL+DELETE). Below the last row, I need to add a vertical border by just copying the border that can be found on A3-AC3 across all sheets. Thanks in...

This code is SOOOOO close to being right, but I cannot for the life of me figure out what I am missing. The part where I autofill the formula to the last row only works on the first sheet and not the rest. I'm sure its something dumb that I'm missing because I am new to the last row function...

I have a vba code to get info from multiple workbooks then paste them consecutively in one worksheet. I want the macro to paste to cell A1 everytime i run the macro, after clearing contents of the previous time i ran it of course. But instead it pastes to the last cell used from the last time i...

Hey guys. I have one more for the experts. I'm trying to create a macro that will find a location, input an equation, and autofill that equation to the bottom of the existing data. I tried recording the macro and using the double click feature, but when I was done, it didn't create a variable to...

Hi All, I would like to select a row after the last active row in the excel sheet. for example: imagine I have data till a row say 151 and i would like to select row 152. the number of rows in my worksheet always varies. Thanks, Raj

I'm having trouble with the task of writing the code inside a macro to perform the task of locating the last active row of data on an open spreadsheet and then using the corresponding row number to define the Range of A10:Zxx A10 is the beginning row/column cell and Z is a known last column...

I have a macro that when its run it opens another workbook and selects specific data, based on conditions someone has on the original sheet, then copies the data to paste onto the original sheet. I have a code that works but when I try to reference the last cell on the sheet I am opening it...

Hello, I am wondering how I can configure the code below so that only the active rows (those with data in them) will be copied into the new workbook. Any suggestions? Private Sub CommandButton1_Click()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...