recorder

Evening, I have a few macros that do various thing. Ordinarily I would use the Macro recorder to help me but the macro recorder doesn't work with Queries & Connections. Are you able to tell me what code I would need to put in in order to create a Macro that gets me to the Source option that...

Still learning the VBA ropes and I know "select" s/b avoided whenever possible, so I'm posting this. Assuming data is in Range("C136:E139") and I want to copy the data in D136:D139 I used the code Range(Selection,Selection.End(xlDown)).copy which was straight from the macro recorder... Is...

I have the following code (from the macro recorder) Sub Macro3() Range("A1").Select ActiveCell.FormulaR1C1 = _ "blahisfgkjdfgvhdzlghfdzgkljdfzghkldfzghdkgh[String to Find]xfkdfhgfdkghfcklgfdlogjud" Range("F6").Select ActiveSheet.Paste End Sub When I recorded the...

Good eveining, I'm trying to build macro to query an Access DB, which works. I'm now trying to remove any fixed filepaths and turn them variable, however the macro recorder I initiated when building to core of the query has placed a comma in the UNC that I can't get rid of? "SELECT...

Hi everyone :), I have a long macro code and I'm wondering if there is a way to simplify it since it has been created from the macro recorder tool. Here is the macro code: https://anotepad.com/note/read/6n32gn I hope that my post is clear enough. Thank you.

In Excel I sometimes use the macro recorder to get me started. I was looking in PowerPoint but can't find it. Does it exist? And if it does, how to use it?

Hi guys Could somebody please help me translate the following function into VBA code: =IF(W8<>"UTG_o", INDEX(UTG_o!B3:B171, MATCH(W7, UTG_o!A3:A171, 0)), "") I want the VBA code to perform in cell V3. I've tried using the macro recorder and it doesn't quite get the job done. Really...

I am trying to set up an odbc connection between sage 24 and excel and getting an error "Microsoft mashup interface error". The error appears when I try to the macro recorder to select fields to import via excel. Do you have any ideas ? Thank you. kind regards Kapil

Code to insert formula is from macro recorder but it fails when run. I read several post on R1C1 but I am lost. Range("AB36").Select ActiveCell.FormulaR1C1 = _...

Code from the macro recorder is inset like this : Sub Macro1() Range("A2").Select End Sub Is it possible to have no inset when using the recorder? Like this : Sub Macro1() Range("A1").Select End Sub

I enter this formula in excel and get the results that I want. When I put the macro recorder version into a module and run it, the code works, but is structured completely differently and doesn't make sense to me. Can someone help explain this? Formula Directly in WS...

Can't figure this one out. Hopefully something simple. In column AN, the formula works the way it should...

Good evening, I am trying to clean up a macro that I recorded with the recorder. Its basic function of the macro is to filter all the data labeled to Phoenix (Column B), paste it on a new tab and then sort and subtotal by column G. I've gotten the majority of that accomplished, but I tried...

Hi all, I'm having serious issues trying to record macros to create graphs in my model. I used the macro recorder to go and select the data to create graphs in hopes that every time I change the data, the graphs would change with my vba code. However, every time I refresh the data it doesn't...

I've been trying to figure this one out and its got me. I have file that I import into Excel from my accounting software. I want to write some simple VBA that will add one more column (named Base), then add a formula on each line of data (=value(left(c2)). When I use the macro recorder on...

Just wondering if you can use excel like a macro recorder program IN THE FOLLOWING WAY. With a macro recorder program the program clicks on specific points of i.e. latitude longitude, so if you had a textbox or userform etc... you could have a script to select a specific point anywhere on your...