Hi,

Does anyone know where i can find a simple list defining each VB
function ?

For example, i have a piece of code :

cells(cell.row,1).Resize(,2).Numberformat = "$ #,##0.00"

and would like to know what the 1 refers to. What the 2 refers to, etc.
Basic beginners stuff.

Cheers,

Andy.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Andrew,

You should lookup Cells and Resize property within VBA Help. It will define
and explain the arguments within there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andrew Edmunds" wrote in message
...
Hi,

Does anyone know where i can find a simple list defining each VB
function ?

For example, i have a piece of code :

cells(cell.row,1).Resize(,2).Numberformat = "$ #,##0.00"

and would like to know what the 1 refers to. What the 2 refers to, etc.
Basic beginners stuff.

Cheers,

Andy.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!