vba

[Delphine]

Hi,

I am new to VBA. I am trying to create a script to do the following:

1. copy a user defined range (only the cells that contains values)
2. paste only the values and transpose the range to a user defined cell

Thank you for your help.

 

[Delphine]

Hi smartin,

I was able to create the macro for a particular range. However, I need to
copy a different range each time and paste it to different cell each time.

 

[Delphine]

This is my code:

Range("A1:K482").Select
Selection.Copy
Range("M1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True

Thank you,
Delphine

 

[Dave Peterson]

And how do you know what range to copy and what cell to paste?