Need help with a copy & paste macro please

[dgarber]

Hi Everyone,

The macro below runs when a checkbox is checked. In a nutshell it copies the value in Row 3, Column F and does a paste special in Row 3, Column E. At that point it applies a formula(=MID(RC[-7],10,3)+RC) to Row 3, Column L. I need to replace that formula to where Row 3, Column L would equal Row 3, Column U. Whether it makes a difference or not this macro can be run through Row 100 with a checkbox in each row.

If someone would have the answer to that I would greatly appreciate it!

Thanks

Please Login or Register  to view this content.

[jeffreybrown]

Hi dgarber,

An easy way to get the formula you want in VBA with the correct syntax...

• Turn on the macro recorder.
• Place the formula in the cell you want
• Select F2
• Select Tab
• Turn off the recorder

[mehmetcik]

Please Login or Register  to view this content.

[dgarber]

Thanks Jeff I was not aware off that but worked great!

[jeffreybrown]

You are welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.