VBA code to be copy and pasted from cells

[Jonnny]

Hi all,

I have a VBA code in cells B2:D5 which automatically updated according to table. And I copy and paste the code to update the macro.
Can VBA somehow take the code from cells and paste?
is there a such function?

 

[Jeffrey Mahoney]

I can see that your using the terms "VBA code" and "macro", but the question doesn't make sense to me.

Are you asking:
"I have formulas in cells B2:D5 which automatically update according to table. I copy and paste those cells to a different part of the worksheet. Can VBA somehow take the cells and paste them elsewhere automatically?"

Yes, A VBA macro can copy and paste cells elsewhere automatically

 

[Jonnny]

For instance, in cells B2:B33 I have VBA code as below.

I made a formula to update the row and column number according to my requirement. But I need to copy and paste to update the VBA code.
My question is, can VBA macro update the code by itself by copy and pasting from B2:B33?

 

[Joe4]

Here is a different thought. Instead of doing something like this, why not already have your base code already in the VB Editor, while you have a control file of values/inputs that the code references/use (via parameters or variables?

 

[Jeffrey Mahoney]

No, VBA cannot copy code into the VBA editor. It is strange to see someone creating or editing code in a worksheet. As Joe said, all of your reference material is in VBA.