counter_insert

  1. R

    Counter of amount of selections from list

    Hi guys, I'm looking for a macro that presents a list consisting of data from another worksheet in the same workbook. I would then like to be able to count and post the result of the counter in yet another cell of the sheet, every time the selection is chosen. Thanks so much for your help or...
  2. P

    Rearranging data with VBA

    This one seems simple but gets hairy as it goes on: I have 2 columns of 182 rows of data (A + B) I need to copy 2 rows of existing data (b10 & b11) ahead of each B cell containing current data. I need to insert 2 blank rows below each A cell with current data. This is what I have (Ignore...
  3. G

    vba insert formula in cell error

    Hi Everyone, I am having issues when I attempt to add a formula to a worksheet cell via VBA, firstly even if I use a variable.string it still falls over, the code I have an issue with is as follows when I check the cell I get =COUNTA('D3':'D300')" instead of getting =COUNTA(D3:D300)" Dim...

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