I am having trouble running a macro that was written to re-name the tabs in a worksheet.
It comes up with a box and "400".
Now my main source of confusion is that I have the exact same code & references in another spreadsheet and it works 100% fine.
Does anyone know what could be...
i need to create printable lables for my products from a list in excle .
From below two coloums
Sku PO Qty
i need to run a macro which gives the below format
How do i combine the 2 Macro to run all at once. Below is the last part of the 1st Marco then the beginning of the second. Should i just add After Next End IF Layering End Sub
For i = 1 TorepRng.Count
cpyRng.Offset(cpyRng.Rows.Count * i) =cpyRng.Value...
Not sure if Powerpoint VBA is the same as in Excel so please just close this thread if I'm in the wrong.
Essentially I have inserted a linked worksheet object in to a Powerpoint slide and I would like this worksheet to automatically update each time this particular slide is viewed. The...
I have a workbook that has a macro in it that other workbooks access. I find that sometimes when I open another workbook which doesn't contain the macro and try to run that other workbook's macro, sometimes it finds it and sometimes it doesn't.
Details: The main WB that has the macro is open...
I created a macro that used to work for a previous project. Now that I have adapted it to a new project, when I run the macro, Excel keeps setting up the problem and the macro does not start running. The code is apparently correct so I was wondering if the problem is:
1. The problem...
wondering if anyone can help me please,
I have a master excel data file and I would like to sort it and do some vlookups with a VBA and then save the data into separate excel workbooks that contains a pivot table and saves into a specific folder location.
I have no VBA experience...
I have a workbook with a macro in a module file called by Ctrl+D but this fails with the error "Cannot run the macro. The macro may not be available or all macros may be disabled".
In the developer tab I can see the macro but the "run" "step into" and "edit" options are all disabled.
Need your help in creating a macro to extract some data from web and fill in an excel. I have tried to work on an existing macro and made few changes to it to as per my requirement. Am able to get the raw data in a worksheet but not able to get it in to an other sheet in required...
after spending quite some time on this forum and finding quite a lot of useful answers, I am coming to you with my problem.
My company (a private clinic) is in need to get some important data on a daily basis. From the software that we use to manage patients, I can run a report...
I have quite a number of sheets whose names end in _A or _B.
I would like to merge all sheets ending in _A or _B under one another., only ranges A:C until last value in column A. (There is always a value in cells in column A, but not necessarily in corresponding columns B and C, that is...
I want to create a dropdown in one excel workbook and the source date is another workbook. Whenever we add more data <gs id="b70b3f28-fa4a-4fc1-a025-beba340ed036" ginger_software_uiphraseguid="c9cce16f-b9fc-4119-aca8-7fb8f30199dd" class="GINGER_SOFTWARE_mark">in</gs> <gs...
I have a Module that has worked for almost a year but is now not working. I've had to rebuild the worksheet because of a un-delete-able style issue that was causing confusion on the part of the end users. So I copied this module into the new workbook.
Here's a sample:
Sub VehInv() cntYear...
Can I password protect the below macro to run between 8.30am and 6pm?
with a message like "Please enter password to refresh the pivot tables between 8.30am and 6.00pm"
But however the I need macro to run without the need of the password between 6.01pm and 8.29am.
I'm very new to the forum and am by no means an excel VBA pro. I have been asked to update our task tracking sheet for the office and could really use some help!
My boss has asked me to create a macro that, when run (not automatically), will cut and move the entire row of a completed...
I am trying to have a macro that will create a pivot table on a sheet using the data from column C and D. I would like for this work on any sheet in the workbook and to run on the active sheet when the macro is run. When I make the pivot table I have no problem and it looks just like I want but...
My brain is hurting from trying to figure this out, so any help would be greatly appreciated : )
I already have a Macro saved to my Personal file in order to use it on any workbook -- the macro is intended to add information to 'Sheet2' of a workbook, as well as paste data from 'Sheet1', as...
I'm looking for a macro or formula to use so that each time data in each individual row is modified on the spreadsheet, it records the date it was last modified in column J for each row/
I've tried various macros but am also slightly unsure of how to use them.
I'm using Excel 2013, if...
Can someone please take a look and hopefully figure out a way to speed up the execution of the following vba code?
Thank you in advance!
Dim LRow As Long, n As Long
LRow = Range("C1000000").End(xlUp).Row
For n = LRow To 1 Step...