MrExcel Publishing
Your One Stop for Excel Tips & Solutions

The right code


Posted by amroo on June 25, 2001 6:17 AM

Bonjour, I'm back with this question , here my code
This for the row number
Dim NUMLINE '
NUMLINE = Cells.Find("100").Row
now I want to select the cells from A1: to A(numline)
my code is like this
Range("A1:A(NUMLINE)").select
It don't run , I have a mistake in the syntaxe, who can helps me on this.
06/2001 Thanks.
A+mroo


Posted by Jerid on June 25, 2001 6:27 AM

Hi Amroo

Try this - Range("A1:A" & NUMLINE).Select

Posted by amroo on June 25, 2001 6:50 AM

Thanks to Jerid from???

Thanks , well done , so simply. Is it possible to know from where you are, I'm from Nancy France it's 15h50mn ant 32°c outside.
A+mroo

Posted by Jerid on June 25, 2001 7:41 AM

Re: Thanks to Jerid from???

I'm from Carlisle, PA. USA It's 10:39 AM Sunny and about 80°F

Nice to meet you, Take Care.

Jerid