active worksheet

  1. S

    How to loop thru an entire activesheet, search and remove a text and shift the remaining cells to the left

    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...
  2. D

    Macro return in the active worksheet

    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...
  3. B

    Send the active sheet or Range of cells as mail

    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...
  4. B

    Command button - Lotus notes email

    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...
  5. C

    Posting to next available of variable worksheet

    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...
  6. B

    Delete Cells Within Column of Active Worksheet Based on Lookup List of External Workbook

    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"...
  7. W

    Named Reference

    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...
  8. L

    ...If Worksheet name contains a certain word...

    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...
  9. J

    Macros - How can I update the active worksheet only?

    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...
  10. A

    How to populate comboboxes with range from a different worksheet?

    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...
  11. R

    Refering to the active worksheet in a macro

    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...

Some videos you may like

This Week's Hot Topics

Top