Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select entire column using VBA
How do you select an entire column using VBA?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select entire column using VBA
activecell.entirecolumn.select
-- Don Guillett SalesAid Software "Phill" wrote in message ... How do you select an entire column using VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select entire column using VBA
worksheets("sheet1").rows("A:A").select ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select entire column using VBA
What you posted raises and error. Perhaps you meant:
Worksheets("sheet1").Activate Worksheets("sheet1").Range("A:A").select or Worksheets("Sheet1").Activate Worksheets("Sheet1").Columns(1).Select -- Regards, Tom Ogilvy "MattShoreson" wrote in message ... worksheets("sheet1").rows("A:A").select ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard shortcut to select entire column | Excel Discussion (Misc queries) | |||
how to select entire row and column in a sigle cell selection | Excel Worksheet Functions | |||
why does this macro select the entire worksheet when run? | Excel Discussion (Misc queries) | |||
Select the entire row | Excel Discussion (Misc queries) | |||
select contents of entire worksheet | Excel Programming |