Tiny VBA problem

Dysprositos

Board Regular
Joined
Aug 3, 2002
Messages
92
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
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
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

Well-known Member
Joined
May 11, 2002
Messages
810
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
 

Forum statistics

Threads
1,148,189
Messages
5,745,241
Members
423,936
Latest member
Conservatopia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top