P
paul
Embarassingly, I don't know how the get the current row
number in VB :-(
Paul
number in VB :-(
Paul
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Wilson
paul,
Activecell.Row
should do the trick.
John
Activecell.Row
should do the trick.
John
M
MacroMan
ActiveCell.Row
should do it...
hth
should do it...
hth
J
John Gittins
Also works if you set the variable up as a Integer, which you can use to do
counts and such with.
counts and such with.
E
Ed
Thank you, John! I know I'll need that in the future as I get more involved
in this.
Ed
in this.
Ed
J
John Gittins
Just a point but the return from "ActiveCell.Row" is an Integer
D
DH
Well. no it isn't an integer when the row number exceeds 32 thousand
something---I think it is about 32760 or so.
Set it to single if you exceed the 32k limit
Dave
something---I think it is about 32760 or so.
Set it to single if you exceed the 32k limit
Dave
A
Alan Beban
Said slightly differently, the Integer variable type and the Long
variable type each refer to integers; the range of the Integer type is
-32768 to 32767; the range of the Long type is -2,147,483,648 to
2,147,483,647. Single and Double variable types can include both
integers and non-integers.
Row numbers are always integers; but if the row number is larger than
32,767, it can't be assigned to an Integer type variable, but can be
assigned to a Long Type variable.
Alan Beban
variable type each refer to integers; the range of the Integer type is
-32768 to 32767; the range of the Long type is -2,147,483,648 to
2,147,483,647. Single and Double variable types can include both
integers and non-integers.
Row numbers are always integers; but if the row number is larger than
32,767, it can't be assigned to an Integer type variable, but can be
assigned to a Long Type variable.
Alan Beban