Thread: I dentifying cell and ranges using n as in For n =1 to 600
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
knowtrump knowtrump is offline
external usenet poster
  
Posts: 1
Default I dentifying cell and ranges using n as in For n =1 to 600

I am trying to run a VBA For/ Next loop that contains an If function
e.g. For n = 1 to 600, If cell C1 ="XYZ" then Range("A1:J1") Select
Selection delete ,End If next n. I want to be able to identify th
Cell and the Range using n. i.e. I want to identify the cell as Cn an
the Range as "An:Jn" . How do I do that

--
knowtrum
-----------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=50266

Reply With QuoteReply With Quote