help me with vba please

  1. T

    Dragging rows when triggered

    I am new to posting and have intermediate excel skills. I have a multiple sheet workbook. I am focused on the “Input” and “Sheet1” sheets. The input sheet is designed so that each row contains all the inputs for that line item. Sheet1 uses the values in the line item to run calculations (i.e...
  2. A

    Excel VBA

    I'm having a rough time creating a macro to do what I need. I know I'm going to need a couple of them to achieve the effect ultimately, but I'm going to start with it in a smaller scale. I have a table that is say about 50 lines. It has 7 columns. I'm looking for it to update a word document but...
  3. S

    Start Condition For Macro

    Hello, I am new with VBA/Macros. I am currently working on a macro and I need the macro to go down an entire column and run everytime the number '2002' is in column R. I have a button set up, but it is currently only working when I am on an active cell. Below is the formula from VBA. Private...
  4. D

    desperately need help! need to copy formula without a range changing, or write VBA for index array

    I have written arrays to populate the following information: 1) the number in the 1st cell in the range containing a NUMBER to F5: {=INDEX(N5:AR5,MATCH(TRUE,ISNUMBER(N5:AR5),0))} 2) the number in the cell at the top of the page that corresponds with the cell found by this array to E5...
  5. B

    Stop running OnTime macro when closed. Please Help!

    Hello! I'm really hoping someone can help me. I have searched and searched and I cannot find a solution that works for me. Our network at work has an issue that when we share an excel file, if anyone on Windows 7 (most of us are on XP) opens the file, it will automatically unshare it. So, we...
  6. K

    Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically have three tables. The first two tables contains rates based

    Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically need to merge three tables into one. The first two tables contains rates based on an issue age, and a fixed period of time. The only difference between them is the first table is for a "Band" class 1, the...
  7. C

    VBA If and loop

    Hi! I'm trying to make a macro that searches a date in cell A1 and a combination of two criteria in cell D1, then i need delete entire row, how can I do this? Follow the example: A B C D <tbody> Date Client Count Historic...
  8. N

    Unhiding a Specific Number of Worksheets Based On A Cell Value

    Hello everybody! :) I have been attempting to cobble together code from different forums for the past several hours to make a macro to unhide a specific number of worksheets based on a cell value, and have failed miserably thus far. To that end, I thought I would try appealing to you nice folks...
  9. M

    How to combine values from multiple rows into a single row in Excel 2007

    I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows...
  10. E

    (tanya) cara mengcopy paste pada named range

    hai semua salam sejahtera.... saya newbie dan tidak mengerti sama sekali vba. saya mempunyai satu file excel dengan 2(dua) sheet 1. sheet pertama (d17:co116) dan ingin saya jadikan lembar input data, dengan data validation list katakanlah (PENDIDIKAN_AGAMA, PENDIDIKAN_KEWARGANEGARAAN dan...
  11. S

    copy value from row 1 (a1 to x1) ,in rows below every 1 minutes when worksheet is open

    i work with stock market where rates are shown in 1st row a1 cell to x1 cell i want to copy value not formula every minutes in row 2 onwards to study changes in rates plz help me to perform this and give me v code and how to include it in excel 2007
  12. J

    VBA Follow.Hyperlink potential Lag

    Good morning everyone, I have created the following code, which takes a search term and creates then launches each hyperlink into Internet Explorer - By and large it works, which is great... but it is almost like the code is too fast for Internet Explorer and it only opens every few search...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top