Select Range problem

[Marcus]

Hi all

I am having trouble working out the code to select the range,

Its difficult this time as i need to work out the Letter rather then number
in the
range().select code

From the code below, you will see i have asked it to select row A7 then
start going accross
until it picks up on a date, where then i want to select the cell, 2 cells
down from that

eg if the date is found on M7, I then want to select range M9 but how to i
show that using the varible i used to find the date, eg using my QQQ code ?

This is the part i am having probs with Range(QQQ & ":9").Select

Full code below, Many Thanks!



For QQQ = 0 To 200
checkfordate = Cells(7, 1 + QQQ).Value
If checkfordate = dateoftt Then GoTo doneqqq
Next QQQ

doneqqq:

Range(QQQ & ":9").Select ' to equal range(M9).select somehow ?

 

[Anders Andersson]

If I understand you rigth this will help you.

For QQQ = 0 To 200
checkfordate = Cells(7, 1 + QQQ).Value
If checkfordate = dateoftt Then
Cells(9, 1 + QQQ).Select
Exit For
End If
Next QQQ


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

 

[Marcus]

Theres a good lad!
Cheers very much!