View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fuerteventura Fuerteventura is offline
external usenet poster
 
Posts: 1
Default VBA Code for Selective formula writing


I need to write some VBA code which will write formula into several row
- however, I want it to select which rows it writes the code int
depending upon the following

Sheet1

(Row Number) ID Price
1 1234 (Formula which will be written if applicable)
2 4321 (Formula which will be written if applicable)
3 5678 (Formula which will be written if applicable)


Sheet2
ID
1234

In this case, I would only want to write the formula into line 1 i
sheet1.

is this possible? maybe an If statement or something or a For Each Row
= 1 to X????
Cheers

--
Fuerteventur
-----------------------------------------------------------------------
Fuerteventura's Profile: http://www.excelforum.com/member.php...fo&userid=2658
View this thread: http://www.excelforum.com/showthread.php?threadid=39856