macro - run

Hi There. I have been saving my macros (procedures and functions) as excel add ins so that if I need them again, I just add that specific macro in (my job doesn't involve a ton of excel work so anything that I do with VBA I want to make sure I will have it for future reference). I can add in...

Hello to all. If anyone could help I would be much appricative!! I would like for this macro to continue to copy and past data from one work sheet into another, but I am not sure how looping works. I put together a quick macro of what I basically trying to do. A2 will change to A3, A4, A5 and...

Hello, I have 2 days that i try to do this and it just wount work" I have a worksheet called "Menu" that contains in column A each name of the 680 sheets that are in the file. each sheet has same structure-containing daily actions made on that sheet : sheet384: h55="24 Dec" g55=210100...

Dear Sir, I am trying to have a code (to be written for macro) for performing Sub-Totals in the column I excel sheet as a part of automation. The rows will be dynamic and No. of rows for each sub-total changes every time. The sub-total shall be based on certain criteria which will be in other...

Hi, I have a macro in one of my excel files that basically selects a list of cells from another page in the workbook and pastes those into the active cell. (it is a list of locations and nominal values) for example I would run this macro and paste it into say cell H30 tand it would fill in down...

Hi, One of my Daily tasks at work involve preparing time stamp report. I run an SQL Query and get the data I need. Now inorder to present the data to relevant people I copy and paste the data on a template which is named "Promise Data Master" then the second excel file which is called "Hourly...

Hello - I have 65 rows of data; each cell contains anywhere from 5 to 8 comma delimited values that need to be housed in their own rows. Here is an example of my data: Cell A2: 0x460297gpr,9806458rtgjd,0x5641313746fd,9x44564fs4f5s4f5ds3,5x4f35sd4f3sd4f3s Cell A3...

Hi everyone, I am new here and I really need your help. I am creating a excel macro to copy some information to a word file as plain text, after that, I am trying to format the pasted text. The macro runs fine once, the second time I try to run it, I get the run-time error '462'. If I tried...

Hi all, I am very new to macro and VBA writing and see that there are a lot of very talented folks on this board who may be able to help. I have 2 workbooks I work with daily. One workbook (call it GlobalData) contains global data where any of 50+ fields could have changed each day. The second...

I'm trying to run a macro or function so that if any cell in a certain column is selected a message will appear in a different cell. So: If cell A6 is selected, Cell A1 will say: A6 selected If B10 is selected, cell A1 will say: B10 selected

I am working with a list reconciliation tool that was put together on Windows 7 using Excel 2003. It works well for small amounts of data, however I would like it to be able to run through about 10,000 rows of data without slowing down significantly or even freezing up. Reviewing the macro VBL...

I want to create a Workbook which expires at a certain date and deletes itself. I'm creating a macro and using the .KILL function in the Workbook_Open procedure. However, is it possible for someone to open the Workbook and bypass running the macro in Excel 2007 ?

Hi Folks: I would like to fire a macro (to unhide specific worksheets) when a selction is made from a data validated drop dow cell. For example, let's assume I have a named range of comprising the names of several fruits" Apples, Bananas, Cantelope etc. One the user selects Apples from the...

i am having a sheet1 where each time i am getting an email from someone the vba brings some info in my sheet one info in first available cell in column A and the other info next to it on column B, now i want to make that each time i am getting new info then a macro should be fired, after the...

Hey guys, I have a very weird problem re using a specific short cut to call a macro within Excel. I posted on a different site but got little help. I have been really puzzled by this problem. Please help me out. In my office, we have a macro (let's call it macro A) that everybody needs to...

Hi, I work for a printing company and we recieve a weekly .csv database that provides us the data to print and fulfil a mailing campaign. The number of records vary each week (2500 to 6000 +). We have to validate certain fields of data and "suppress" the fields that don't meet the criteria. We...

I use Add-Ins all the time and have the folders all added to the The error I am getting is "Cannot run the macro " xxx Macro Location xxx". The Macro may not be available in this workbook or all macros may be disabled." I developed the macro and add-in on this machine, and have used it...

Does anyone know how to start a macro based on a cells value??? Thx.:confused:

Hi All, First post so please be gentle :) I've written the following macro to insert a row, copy some cells from another sheet and then paste them into the new row. The problem occurs when I use this macro more than once it crashes Excel 2003 out! Any help greatly appreciated: ### Code...

I have a simple Macro I run on my sheets. I want it to run each time I Deactivate a Sheet but I don't know how to make it happen. Can anyone help? Here is the code **************** Sub Refresh_Page() ' ' Refresh_Page Macro ' ' Range("Q8:s8").Select Selection.AutoFill...