Paste from active cell to range of column

chriefth

New Member
Joined
May 12, 2018
Messages
1
Hello colleagues,

I am new here and also new to vba and I would like some help with coding. I implement a script for my company and I am in the final step.

I have the active cell on which I have a formula that has been recordered and I selected the active cell I copied and I need the code so as to paste it to the specific column "L". Bear in mind that in this column there are values that are with "EUR" that I want to be excepted and I want this formula of the active cell to be pasted into the cells that are with 0,00 value so as to take the formula.

This is the coding that is missing and then the script is finished.

If you could help me I would be grateful

Cheers
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
chriefth,

Welcome to the MrExcel forum.

So that we could get it right on the first try, can we see your actual raw data workbook/worksheets, and, can we see what the results (manually formatted by you) should look like?

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,629
Members
452,661
Latest member
Nonhle

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