Recently I updated from 2004 to 2010 and have run into an issue with copying into a protected worksheet. There is a range that is a user input that must be copied in from another worksheet, but when the worksheet is protected the cells become locked as soon as copied.
Basically I would like...
Hi!
I need some help with a code that copies values from one sheet, and paste them into another sheet. But the thing is that the values in the original sheet change weekly, so basically I want to keep record of the each week of the year in the other tab.
I would really appreciate any comments or...
I have a sheet with data, where I want to copy only visible cells to an new sheet. There are already hidden rows (through filtering), but I need to hide additional rows, as well as the columns I don't need.
The reason I paste as picture is that I want the copied cells to look exactly like in...
hI ALL,
I NEED A MACRO that copies a range of cells say from c1 to c3 six times in Column F.
say if the value in the range C1 To C3 is a b c.The range F1:F18 should have the value a b c a b c a b c a b c a b c a b c.
Please reply..urgent and advanced thanks...!
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.