Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range of a whole column in Cells syntax
Hello
Can someone please tell me how to access a whole column using cells(). For instance range("a1") =cells(1,1), what is the cells equivalent of range("a:a")? Thanks in advance. -- Hal |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range of a whole column in Cells syntax
Cells returns a range object and from there you can select the entire column
cells(1,1).entirecolumn HTH "Hal Styli" wrote: Hello Can someone please tell me how to access a whole column using cells(). For instance range("a1") =cells(1,1), what is the cells equivalent of range("a:a")? Thanks in advance. -- Hal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range of a whole column in Cells syntax
Hi Hal
Cells are cells. Columns are columns. Rows are rows. Use Columns(1) as in MsgBox Columns(1).Address HTH. Best wishes Harald "Hal Styli" skrev i melding ... Hello Can someone please tell me how to access a whole column using cells(). For instance range("a1") =cells(1,1), what is the cells equivalent of range("a:a")? Thanks in advance. -- Hal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with the syntax for using range name in a formula? | Excel Discussion (Misc queries) | |||
syntax for countif when cells fall within a numerical range | Excel Worksheet Functions | |||
Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
range and cells syntax | Excel Worksheet Functions |