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...
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...
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...
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.