active worksheet

I'd like to put together a userform so that I can choose from dropdown menus the workbook, the worksheet and a macro. I have a number of macros that are used for modifying certain reports and would like to be able to run the macro based on selecting 1 workbook then 1 worksheet then 1 macro so...

Hi, I need some help please. How do I search the entire active worksheet for a particular word, say "XYZ", remove/delete a text contains "XYZ" and be able to shift the remain of the values in that row one cell over to the left? A1 A2 A3 A4 A5 XYZ B1 B2 B3 B4 Result...

Good Day! I am running a macro that copies, parses, and selects, data from an input page. I have buttons assigned to the macro on each worksheet page I need the information pasted too. (so around 30 total worksheets, 1 for each day.) The problem I am running into is that it continually...

Hi,# I use the following code to send mail to a person through lotus notes. But i want to send a specific page or the Range like (A1 : K50) as an attachment. Someone please help me to alter the code so that it works in the way i want it to. Public Sub CommandButton21_Click() Dim Maildb As...

Hello, my name is bharath. I am now working on a complex process planning. i have integrated data from various sources and grouped in several pivot tables according to my boss's requirement. My questions are as follows: 1. I know how to filter the Pivot table (I use slicers in my case). I want...

Hello I've got code which creates a new worksheet with the name of your choice (an employee's name) with a view to creating a staff database with individual records. The next stage of the process is to input all their details. At the moment, these details are inputted on to the next available...

I'm trying to find some VB code to help me delete cells within a specified column of my active workbook by referencing a list in another workbook. Specifically, I want to delete all cells in my current worksheet that contain traditional personal email URLs such as "@gmail.com", "@comcast.net"...

I have created a named reference that stores functions to get around the 7 nested if statement limit for functions. However when I add the reference in the name manager, it automatically appends the current worksheet name in the variables. original formula...

Hello, I am trying to create a macro to run in a document that contains many sheets. There is one sheet at the beginning, and then subsequent sheets which all have a calendar month in the title. What I want the macro to do is recognise which 'month' it is in a paste a value into its...

I am using excel 2010. I have a macro-based employee leave system that works by couting the number of days shaded with a certain colour and thus calculating leave days taken, remaining and entitled... I have a single workbook with multiple sheets for different employees. However, when I...

I wonder if anyone can help me. I'm trying to load the comboboxes with data from a different worksheet. However, no matter what code I try it only loads from the active sheet. Here's an example of one of the subs that I tried. Any help would be greatly appreciated! Private Sub...

Hi I am new to VB and recorded a macro to update a number of graphs in a number of worksheets with additional data. This is what i recorded Sub EDITCHART2() ' ' EDITCHART2 Macro ' Macro recorded 6/23/2009 by mcarag ' ' Keyboard Shortcut: Ctrl+Shift+W ' ActiveChart.PlotArea.Select...