recording

  1. G

    Recording changing cell

    Hi guys I have been struggling to find a solution to an excel problem I have. As the title says I have a cell in my spreadsheet that is constantly changing "H10" and I would like to record this for the last 5 seconds at 1 second intervals. But this would be triggered to start recording with...
  2. L

    recording marco timing

    Hi Can I change the timing in recording macro. For example I want to copy a cell and then paste it to another location after 3 seconds. Can I do that by Recording Macro. Not written a code. Thank you very much.
  3. B

    query macro help

    Hi, I hope I'm wording this correctly. I have a large CSV file that I import using data>get data>from CSV file. it imports into cell A4 and it's a query. I tried recording a macro to format it like i want to but when I use the macro the column that I moved from column H to column B shows up...
  4. L

    Recording a Summation Macro

    Hi I am reading a course outline and it says students will learn Recording a Summation Macro Recording Consolidations Recording Divisional Macros My question, what does summation/divisional/consolidation macros mean? source...
  5. B

    Excel Recording a macro

    Ok guys i know the short cut for starting and stopping a recording macro is Alt+T+M+R. My problem is im wanting a macro that will insert a new Row in my table, in form view. (Select anywhere on the table, click on insert at the top ribbon, then click on "Form" on the top right ribbion, then...
  6. M

    recording changes to a value so i can plot a graph

    Hi i'm having an issue working out how to go about recording changes to a value that's dynamic (Changes from month to month) so i can make a graph. Bit hard to explain so i'll post a screenshot. If someone could point me in the right direction happy to learn If any additional info required...
  7. C

    Use VBA to run/terminate Shell command and save file

    Greetings! I have a shell command that uses curl to capture live audio output from a port on our call server. Sub RecordAudio() Call Shell("cmd.exe /S /K" & "curl 92.68.0.10:8888 > i:\voicetemp\voice.wav", vbMinimizedFocus) End Sub What I would like to know is; 1) how can I stop the...
  8. Y

    Macro to call for recording and then loop

    I know how to loop using this code Sub WorksheetLoop2()<code class="" style="box-sizing: inherit; font-family: Consolas, 'Courier New', Courier, monospace; font-size: 1em;"> Dim Cur As Worksheet For Each Cur In Worksheets '===================== 'This line calls for recording...
  9. Q

    Macros Runtime Error

    Hi, I have been trying to run macros from my source file to run on my target file. I even selected use "relative reference", however every time I start to work on my file it gives me a runtime error code 1004. I understand that is because it cannot source the reference data. When I debug, it...
  10. P

    Adding a shadow for a cell in VBA (macro recording fails)

    I try to add a shadow in a cell (Format toolbar - Shape effects - shadow). However, if I try to do the same in macro recording, the recording is blank. When one clicks the Shape effects - shado, Excel actually creates a rectangle just the size of the cell and gives it a shadow; somehow the...
  11. L

    Missing parts of pasted formula when when recording macro.

    Can someone please help me? When I copy the formula below(which works) while recording a macro, it seems to have parts of the formula cut off in the code (highlighted below is what the macro creates) for example, the original formula, looks in the data sheet for "highway Tripper", as you can see...
  12. B

    Stop recording macro

    I am using Excel 365. When recording a macro to open the "custom header" the stop recording button is unavailable. Is there a way to access it or a keyboard shortcut to stop recording? Thanks
  13. O

    Adding Units of minutes and seconds

    I am creating a recording log and would like to add the various recording times - i.e. 16 tracks of various times such as 1:35 and 2:46 and 1:22, etc. When I of course add up sixteen various times they do not total properly. Thanks - Dave, The Olive Oil Guy
  14. L

    Is there any difference between a VBA Program and Macro?

    Hi That question is answered in the article below. The author is saying macro and vba are different. I am very confused now. I thought macros (recording macro) are vba sub routines, am I right? I thought these recorded macros will be saved as vba subs...
  15. L

    recording chart macro does not work

    Hi I created macros by recording my steps. macros to create table, fill table, change color of the sheet, clear the sheet and drawing a chart. I assigned buttons to these macros and they all working except the Chart one. When click on Chart button I get run time error but if i clicked on End...
  16. L

    de-select the whole sheet

    Hi I can select the hole sheet by clicking on the icon on top left corner. How can I deselect a sheet with out clicking on any cell? the reason I want to know because I am recording macro that will select and delete the whole sheet then deselect. Thank you
  17. G

    Writing Vlookups in VBA

    Hello, I am always recording and adding vlookup into Marco's as below, I will like to understand how to write it within vba rather than recording everything, also if possible how only to put the result in the cell , rather than the formula. the basic formula is =IFERROR(VLOOKUP(AB2,'SQ...
  18. M

    VBA Code for creating a pivot table

    Hi I have tried recording, and looking through google and editing code. But for the life of me I can't get my button to work. I just want to: 1. Select current range 2. Create Pivot Table on a new sheet 3. Put one field in row 4. Put one field in column I thought recording would be easy...
  19. T

    Simplify new sheet creation?

    I'm running 2016 and need to configure a spreadsheet so users can click a button to copy a sheet named "Template" and have it placed as the leftmost sheet. I'm not a coder, and have tried to go through the process via recording a script but it's not working as expected. A little help, please...
  20. T

    Having Issues With Page Footer When Recording A Macro

    Hi all, I having issues with recording a macro to insert a page footer that shows "Page 1 of 9" for example, after recording the code looks correct however all I am getting is "Page 1" only - has anyone else had this issue and how have you managed to overcome it? The code I can see isCode...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top