vba

D

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.
 
S

smartin

Delphine said:
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.
Click to expand...

Hi Delphine,

Not to evade you, but since you are new to VBA I heartily suggest you do
a little experimentation by recording a macro as you perform the steps
above. The code it creates will be specific to your selections, but it
will show you how some things are accomplished in VBA, like selecting a
range and paste | transpose. Often you can modify the code easily to
generalize it.

Do write back if you get stuck!
 
D

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.
 
S

smartin

Ok -- good start! If you could post the macro you have so far, we will
see what we can do.
 
D

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
 
Top