Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range problem
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range problem
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range problem
Theres a good lad!
Cheers very much! Anders Andersson wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select used range | Excel Worksheet Functions | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Range("cell").Select Problem | Excel Discussion (Misc queries) | |||
Select Using Range | Excel Discussion (Misc queries) |