copy files from one worksheet to another

[freak11]

hi,
got this code and i want to copy the cells from recording.xlsb to openWB, openWC and OpenWD but somehow it does not work. what is the problem?

Please Login or Register  to view this content.

[xladept]

You need to be more specific - your workbooks are actually ranges in "Thisworkbook" which must be already open

[HaHoBe]

Hi, freak11,

you should adapt the code as I think it to be no good programming to use ActiveSheet and hoping for the user to have the workbook closed with the relevant sheet on top. And you really want to go from Row 5 up towards the first empty row?

Untested:

Please Login or Register  to view this content.

Ciao,
Holger

[freak11]

Hi holger,
thanks for the correction but your code copies all the values from N5 to the set openWb. why is nothing being copied to openwc and open wd?

[HaHoBe]

Hi, freak11,

I had corrected the fault in the Forum when I decided to make more changes in my testbook (but didnīt think of that change nor copied it over again into the workbook) - sorry for that.

The ranges need to be preceeded by a dot like

Please Login or Register  to view this content.

in order to reference each workbook whereas the code I posted would rely on the ActiveSheet no matter which workbook I wanted to copy to.

Ciao,
Holger

[freak11]

thanks. it works now but how would i incorporate the command below into the code?

Please Login or Register  to view this content.

[HaHoBe]

Hi, freak11,

I really donīt get what you are asking as I canīt find any relation to the opening post but maybe instead of

Please Login or Register  to view this content.

itīs

Please Login or Register  to view this content.

Ciao,
Holger

[freak11]

I am sorry. I did not clarify myself. I wanted to insert this code:

Please Login or Register  to view this content.

In order to draw a stock chart in the sheet openWB WC OR WD, but instead it does it in the sheet called recording.xlsb (the original sheet from which i run the macro).

For drawing the stock chart i wanted to insert this code as next step after selecting the range:

Please Login or Register  to view this content.

I cannot run this code before selecting the range and the range corresponds to the value in cell N5. that is my whole purpose.