help/advice

  1. Tim_D

    VBA Structure Best Practices and Code Review

    Hi everyone, I have a functioning Macro and I ventured into unknown VBA code to complete it. After many hours of reading here and other sites, testing, frustration, and finally success, I would like to ask for a review of not only the structure of the code, but also if there are smarter ways...
  2. R

    Assistance with Numbering Sheets Based on Copies Printed

    Hello New member here! I have a process in which I have to print various copies of the same worksheets day by day depending on the schedule. Based on the number of copies printed, I would like each worksheet printed numbered based on the number of copies I print. For example, if I needed to...
  3. M

    VBA: Find and Group All Occurrences of Value, Run Sub, Move to Next Group

    Hi, I need some help getting started on a code. I have a range ("B4:B") of variables that are related by the first four characters (the year). Currently an input box will appear asking which year to run the code in, and the default value is based on the left four characters of the active cell...
  4. CsJHUN

    get all text value from sheet

    Hi! I would like to get all text value on a worksheet into one variable. I managed with cells, its obvious. ... Sheets(Sheets.Count).Select For Each cell In Range("A11:EE500") t = t & " " & LCase(cell.Value) Next cell... But stucked with other object which should have text value. So far i...

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