Cells value insert into macro Formula

**frenic** · 06-26-2008, 05:47 AM

Hello everybody,
help me please.
My Problem. I have the Cells value as examble:
Cells (1, 6) has value "F9:AV9" and this value is variable.
I need this information as parameter to insert in the following macro formula:
Sheets("ARHIV").Range("F9:AV9").Copy
to transpose in to Column.
Maybe is possible?
Thank you very much
Fidele

**lecxe** · 06-26-2008, 07:03 AM

Hi Fidele

If Cells (1, 6) has value the text value "F9:AV9" (without the quotes) you can use:

Please Login or Register  to view this content.

if Cells(1,6) is also in sheet "ARHIV" or just

Please Login or Register  to view this content.

if Cells(1,6) is in the active sheet.

HTH
lecxe

**frenic** · 06-26-2008, 10:05 AM

Thanks Iecxe,
sorry but not works - error '1004'

"F9:AV9" is the text as actual (changeable) information in Sheets(Arhiv").Cells(1, 6) for actual existig rows in the same Sheets.
Solution is "automatic copyng" the rows via macro formula:

Please Login or Register  to view this content.

Salute
Fidele

**royUK** · 06-26-2008, 10:23 AM

Fidele

Please use Code tags when posting code, this is covered in the Forum Rules.

Try

Please Login or Register  to view this content.

**royUK** · 06-26-2008, 10:29 AM

If you are copying & pasting from one sheet then

Please Login or Register  to view this content.

**frenic** · 06-26-2008, 11:35 AM

Mama mia,
it works, it works!
Thank you very much, royUK!
Nice day
Fidele

Cells value insert into macro Formula

LinkBack

Thread Tools

Rate This Thread

Display

Cells value insert into macro Formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions