Row Number and column Name in Vba

[G2K]

Hi All,

how can we get row no and column name of spreadsheet object in VBa.

i want to check vaule of first cell of the column with a variable.

Let Activecell = H15

i want to check value of "H1" on command button click event.

please help.

thanks

 

[snowblizz]

There is a .Row and .Column property you can ask of a Range object.
Range("H15").Row will give you the row number of the cell.
You could also use the .Offset property. Depends a bit on what you are doing.

 

[Sandeep Warrier]

Hi All,

how can we get row no and column name of spreadsheet object in VBa.

i want to check vaule of first cell of the column with a variable.

Let Activecell = H15

i want to check value of "H1" on command button click event.

please help.

thanks

Range(1,Activecell.Column).Value

Will give the value present in the 1st cell of column containing the selected cell.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[G2K]

thanks sandeep for Your quick reply,

I have tried it already and it is generateing error message " Run Time Error '5' Invalid use of command or property"

Spreadsheet1.Range(1, ActiveCell.Column).Value

Please note tht i m using Spreadsheet Object here

Thanks in advance

 

[snowblizz]

It looks like the syntax for range is not correct, replace "Range" with "Cells".

 

[Sandeep Warrier]

It looks like the syntax for range is not correct, replace "Range" with "Cells".

Yeah....

Interchanged Range and Cell properties

shud be Cells(1,Activecell.Column)
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">