macro action

Hi, I have a macro that looks into the cell formula for the reference to another excel file name and sheet name and opens it/activates the sheet name. When I run the macro via Alt-F8 run macros, it works as expected, but when I assign a Shortcut it does open the file but do not activate the...

I have a macro that selects worksheets to be printed from worksheets that carry a value in cell A1. I am trying to adjust the code so that it will print the pdf file with a predetermined name, eg "Output.pdf" and into the folder that the excel file is currently saved I do not have the VBA...

I have data set on Sheet1 and I want to create worksheets based on unique values in Column A, I then want to copy the data and header for this value to the new worksheet.

Hi All, I am in desperate need of a macro that can save out a particular worksheet from the current workbook to a new workbook. In addition to saving out this worksheet to its own new workbook, I would like the macro to also value out (remove formulas from) everything except for a specific cell...

Hi everyone, Am having a litter trouble with Macro in excel. here is my code. Sub sampleworksheet()</SPAN> Dim cursheet As Worksheet</SPAN> Dim j As Integer</SPAN> Dim curname As String</SPAN> Dim channame As String</SPAN> Dim modifiedchanname As String</SPAN> 'itterate all worksheets in...

Hi, I need some help with a simple macro I'm using. I've recorded a macro which selects a few cells in a row, copies them and pastes them again over the same cells (special paste - only values), and I've attached this macro to a button. I would like the macro to repeat the same action on the...

Hello Forum! I'm struggling with a macro issue and am hoping to find insight from the higher power that is you. Essentially, I'm trying to build a macro that runs every time a cell value is changed (in this case cell AC4). The purpose of that macro is to show / make visible one of 4 different...

Greetings, I am trying to make it easy for users to jump around within a worksheet. For example, they can click a button that takes them to a note section. What I need help with is writing a macro to take them back to wherever they were once they are done entering notes. Is this possible...

Looking to use a macro to index down a list copying the value and toggle to a worksheet and paste value into the filter to look at different project details .. Any ideas on how to use a macro to filter for one specific project would be appreciated.. Thanks,:eeek:

I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...

My first post here. I have made a lot of VBA code, but without the basic competence of a programmer (being a process engineer) I always tend to paint myself into a corner... Now here is the deal: I made some tedious code to construct a FormulaRange...

Hello, The below code is giving me problems depending on the status of AutoFilter. If the Autofilter is on when the macro is envoked, it does not filter the desired area because it turns it off, if the autofilter is off it filters the intended area. If I write in Selection.AutoFilter and it...

Hello, I am using the following macro to start a double click event to start a combobox and also enter "1" or "0" in different adresses from the combobox addresses. I just figured out that in the below macro, I guess the error handler or the window reset it also empties the list in Undo...

Hi Folks, I have excel documents where many (thousands) of the cells contain an email address. I need to delete these cells (that contain email address) only from the excel files. Are there any Macro or something that I can use to do so quickly and easily?. (a common feature of the cells is a...

Hello! I'm using a shape to contain a delete function for a particular row of data. Since there are multiple delete shapes cooresponding to different rows, I need to use the activated shape's position data to determine which row needs to be deleted. I can't figure out how to call the shape...

Hello Folks, I am looking for code to put into macros I've written that request from the user "Are you Sure you want to run this Macro" and if yes, the macro continues, if no, it resets. Any suggestions?

When you open a macro in Design mode, you get the four columns, Macro Name, Condition, Action (with the parameter below) and Comment. Where is this list of actions in VBA? I've searched the database's Scripts container, the project's AllMacros collection, all properties for both -- nothing...