rangea2.select

I have numeric values in another sheet by the name of summary. If cell value in summary sheet example F5 is > 0 or less then 0 or <> 0 only then i want to run the macro for that particular company . The problem is if i use if condition it stop running the second macro if the first value is...

Hi, I'm new to VBA, I'm recording a macro to format a specific file that a team uses to work through a que, I'm trying to get my macro to reference the workbook regardless of the changing number in the file. This name change is caused by the way the file downloads in certain browsers i.e chrome...

No clue why this works on my machine, but throws a 438 on another user's machine. Anybody? This is all my code. It's my boss, so I didn't exactly want to get him involved in debugging. Let me know if I MUST. I figure it's something I can't pick out because I steal code, I don't really write...

I need to include a line that will find the next blank cell in column A and then run the macro. Here is the macro as it is now: Sheets("Sheet2").Select Range("A1").Select ActiveCell.FormulaR1C1 = "=NOW()" Range("A1").Select Selection.Copy Selection.PasteSpecial...

Afternoon, I have tried recording the below macro which looks to combine the data on 9 tabs into one tab. Problem I have is that the data on each of the 9 tabs is dynamic and may vary in number of rows. I believe I have identified the problem and have made the code bold and underlined. Any...

Hello: I want to select an entire row and I have already recorded a macro but the range will vary depending on the file: Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Select Range(Selection, Selection.End(xlDown)).Select Rows("73060:1048576").Select...

Apologies in advance for the basic question. I was slowly becoming a whizz at VBA a decade ago, but I'm picking it back up and need a few pointers I'm making a macro to take info from sheet to another, and then to fill forumula that I've entered into the sheet already (that'll be a separate...

To, All experts, pls provide me some professional code for below line of code..So i can learn the new.. Windows("Book1.xlsm").Activate Sheets("sheet1").Select Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy...

Hello, I inherited an Excel file that has a macro. Basically, you are supposed to click a button and it updates from two different files saved in a network drive. The updating works fine, however it is supposed to set a print area and perform a custom sort. The issue I have been asked to fix is...