macro's

  1. G

    Changing the subtitles stops VBA working and form printing

    Hi, I already have a sheet set up with an embedded form that pulls data from the spreadsheet and prints using a button programmed to print each numbered entry. A second button also saves a pdf copy to the system. However I need to change the subtitles in the spreadsheet and form as they have...
  2. B

    Extracting Alt Enter data by Creating rows underneath using macros

    Hello All, Ok so here is my data set -- removed inline image --- Top is what I have, bottom is what I need. Is there a Maccro way to do this? I tried using text to columns using the Alt H command to bring the data out, then indexing it down and that works for doing it 1 row at a time, but...
  3. A

    Excel applications in SharePoint

    Hi All, I have created an excel application which analyses some data held in SharePoint via a SharePoint list. It then creates an excel export and closes the initial workbook. I have tried uploading this to SharePoint for use however this causes no end of errors which did not occur when i...
  4. A

    Autofilter method of range class failed

    Hi, I am trying to write a macro which takes data input into a userform and runs various autofilters based on this. A particular part of my code is triggering a Autofilter method of range class failed. The code is If RB1_chk.Value = True Or RB2_chk.Value = True Then WSE.Activate...
  5. A

    Pivot tables - multiple consolidation ranges

    Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I’m having issues with a pivot chart which has source data from multiple consolidation ranges. I have 4 sheets with data in them, 5 columns in total (A:E), all 4 sheets have exactly the same format...
  6. A

    adding question numbers

    Hi, I have a macro which produces a worksheet of specific questions according to what criteria a user choses on a userform. It then copies this data into a new tab. There are 3 columns, Question Number, Question and Evidence. My problem is that because the data copied is a mere extract of a...
  7. A

    Is it possible for a macro to search for a phrase and export if true?

    Hi, I have a large sheet which tracks initiatives. I would like to write some code so that a user can click on a button which opens a search box, they can then enter a phrase. What the macro will do is search the data (Columns A-AA) and where it finds a match in text to the phrase it exports...
  8. B

    always turn on macro's

    Hi, Is there a way to always turn on the macro, even if you push the (left) button to turn off the macro's? Regards, Bengtar

Watch MrExcel Video

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