selected rows only

  1. K

    send an email when a cell is changed for selected rows only with VBA

    Hi There, I have a spreadsheet that contains employee claims, eachline is 1 claim which has a unique identifier I need a way for the user to be able to select rows and havecertain cells from the selected rows to be added to an email (recipient,subject and body template will be static) The...
  2. M

    Ungroup selected Rows with macro/vba

    Hello, have got data more than 1800 rows and applied 35 grouping's to it (rows count isn't same for these grouping's) Now, I want to ungroup one (of my choice) of 35 groups & I wouldn't mind if it allows one at a time while sheet remain protected all the time... any advise on this would be...
  3. Phil Payne

    How do I set a 'Worksheet_Change' event for part of a worksheet?

    Hello all, I am very much a VBA beginner and I cannot see a way to modify my code. I hope someone can help. The first part of the code below checks for a change of Status in the Status column and on change fills the adjacent Cost cell with appropriate colour then enters current date into the...

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