Copy and paste multiple cells into one cell

[akalehzan]

Hi All,

I have the following VBA code in Excel that looks in sheet called mri.txt for a cell called “AcquisitionMatrix”,

Then goes one cell down and two cell to left and copy them all into Application.Workbooks(imgMain).Worksheets("Sheet1").Activate cell “AC2”,

But for some reason it copies the field’s name as well such as:
AcquisitionMatrix , 0, , 256, , 256,.

Is there a way to avoid copying the filed name into cell AC2? Such as :
0, , 256, , 256,?


here is the code:

Please Login or Register  to view this content.

Thanks for any help.

Abrahim

[rylo]

Hi

Rather than rewriting your code, change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

[akalehzan]

Hi rylo,

That did it

Thanks for the help,

Abrahim