macro-help

  1. S

    Finding and Selecting Cells by Color

    Hi! I have a question regarding my macro. What I want it to do is search for all the cells that are blue colored and select all the cells that are blue colored. I, then, want it to take only the blue colored cells and email them. Help please? I have the email part down, I just can't seem to have...
  2. K

    Need a macro to search for a specific list of words and run an other macro if found

    I have been very puzzled with this one. I am looking to create a macro that will search my spreadsheet for specific list of words. If any of these words exist I would like to excecute a second (wordart) macro. I would like the macro to execute each time the file is closed, so that if the found...
  3. N

    Run-time error '1004': Shared Workbook and Macro

    Hello All, I am having an issue with a macro abd sharing a workbook. The macro enables me to using grouping while protecting the worksheet. Here is the code: Private Sub Workbook_Open() Dim wksht As Worksheet For Each wksht In ThisWorkbook.Sheets With wksht .EnableOutlining = True .Protect...
    • ndeboni1
    • Thread
    • excel macro-help run-time '1004' shared workbook vba
    • Replies: 1
    • Forum: Excel Questions
  4. andrewb90

    Issue with using multiple cell refs in a macro

    here is the code I am currently using: Sub shift_1() Sheets("Input").Select If Range("B2") = "1" Then '**********************1**************** Sheets("B1").Select Columns("G:G").Select Selection.Insert Shift:=xlToRight Range("G1").Select 'TOTAL ACTIONS...

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
Back
Top