Tiny VBA problem

[Dysprositos]

Hello to anyone who can help me with my little problem.

Its with VBA,
I want my macro to select a column in another sheet, called Relay

So what am i doing wrong? my code is as follows.

Worksheets("Relay").Cells("C:C").Select

 

[DonkeyOte]

sheets("Relay").Select
Columns("c:c").select


If you want to copy it

sheets("Relay").Columns("C:C").copy


Can I say that the easiest way to find the code is to record doing it - and then view the result.

 

[stevebausch]

On 2002-09-27 03:36, lasw10 wrote:
Can I say that the easiest way to find the code is to record doing it - and then view the result.

lasw10,
You are correct in pointing this out. I keep mentioning this, myself. Doesn't seem to do any good.
Steve