IF then Active Cell

  • Thread starter Thread starter cole7011
  • Start date Start date
C

cole7011

any ideas on how i would do the following ??

If cell C7 equals Apple then active select a cell g1 in worksheet
however if it pear then do the same but this time select G2 and so wit
different condtions and different locations to were it needs to selec
 
Select Case range("C7").value
Case "Apple"
Sheets(1).activate
Range("G1").select
Case "Pear"
Sheets(1).activate
Range("G2").select
......

Case Else
msg="Can't find fruit, can't select cell"
msgbox msg
end select

May work for you

Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with vba 3
CONCATENATE IF macro or function? 3
Save cell location to a variable 3
Cell Toolbar Dilemma xl2013 13
Active cell plus 1 2
Create worksheets from data 1
My 1st IF-THEN-ELSE Procedure 8
cell to worksheet 1

Back
Top