active worksheet

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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"...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top