worksheet cell code vba

  1. J

    Excel count if sheet name matches with Column E with cell value

    I am using the formula B1=COUNTIF(INDIRECT(A1&"!E:E"),"<>")-1 But when there is space in between in Column A then I am getting error as #REF!, for example when I have cell value as "REDORANGE" its showing value but when I am using "RED ORANGE" its showing #REF! and my sheet name is "RED...
  2. K

    Copy rows if cell a is green in any sheet to a master sheet ! Vba

    I am trying to do something relatively simple and can't seem to get the copied rows to show up. I would SINCERELY appreciate ANY HELP!!!!:confused: 1. I have 10 sheets in a workbook (I inserted all of these based off of the same macro enabled template) 2. I am trying to copy the highest...
  3. A

    Running Macro on multiple worksheets using prefix

    I am working on a worksheet with multiple tabs although I need to copy data from worksheets that start with only "2018 and 2017". From these sheets I wanted to copy range - using variables (say I wanted to copy a range between column A to L but the range should be dynamic ) and then paste the...
  4. S

    Cancel the Private sb worksheet_change if cell selected empty

    Hi ! I use this formula to ask employees to confirme the data they enter in a cell and after the data is lock. It's working very good but i have a little probleme: When we play around and click on a empty cells, the cell become activated en then we click outside of the same cell ..the vba...

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