macro recorder

Hello everyone, I recorded a macro to print two sheets of a workbook with the correct settings. It is supposed to print without comments and notes. The problem is the following : when i record the macro, everything is fine and notes are not printed but when I replay the macro, notes comes...

Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my range will always differ for my data that I copy. I have data sets in every 4 columns ("A:D"), ("E:H") and so on but I just want the data from ("A:B")...

Hi Everyone, I created a macro using the Macro Recorder but wanted to see if there's a much easier way to filter and paste a new sheet with less code. I want it to filter for anything within the column and not a selected range ("$I$1:$M$83"). Would I use something like to select anything...

Hello Everyone, This is my first post so I hope I don't put to much information in here. I recently decided I wanted to make my work automated and since I use excel daily I came across VBA. Recently started using Macro Recorder but don't know much about VBA. I've been watching videos daily for...

Using either Macro Recorder or VBA I need to: Save As Select Rows Delete Selection Select Cell Delete Selection Save Thanks, Rick

I'm receiving a Runtime Error '9' Subscript out of range when I try to run run the below code. I've tried changed the Range("A5").Select but that didn’t help. The code below was created using the macro recorder. This is the part that is highlighted when debugging Windows( _...

Hi There - I am simply trying to create a pivot table using the macro recorder. After creating the code, I removed the previously created pivot table and attempted to run the routine again. However, I received a run-time error 5, invalid procedure call or argument error. The code is stopping at...

I'm using Excel 2010 with Windows 7. I'm new to macros. I've been recording macros and trying to assigning a keyboard shortcut in the Record Macro window but, they don't seem to stick. The macro keyboard shortcuts work with the first use but, don't work if I close Excel and try to use them...

Hi, I'd like to know if it's possible to copy and paste a pivot table with a customized design into a new tab leaving only the value and format using VBA. I tried copying and pasting as value and then format but failed, the custom design wasn't carried over as painted format (Font section in...

I recorded a Macro and it functions properly. The problem is that I had given a name to every range that the Macro performs an action on, but the Macro recorder still referred to ranges by their Cell names (for example "D5:D8"). Is there some way to make the Macro Recorder use the Defined...