View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sunnmann[_2_] Sunnmann[_2_] is offline
external usenet poster
 
Posts: 1
Default Problem with Macros in VB (2 Parts)

So, what I get here is an error that tell sme no blank cells found. Jus
to make sure I am not going insane, I will give a bit more detail o
Question 1.

I have Columns A-G that i use



Machine Name - Bulletin - Q Number - Product - All -
High - Low
Mach 1 - MS04-002 - Q234567 - MS Office - (code) - (code) - (code)
Mach 2 - MS03-345 - Q654321 - MS Word - (code) - (code) - (code)
Mach 3 - MS04-126 - Q098765 - MS Playa - (code) - (code) - (code)


What i would like is for that code to go from Column E (the word All i
in E1) and print in the functio
=ISNUMBER(MATCH(RC[-3],ITPatches!C[-4],0)) all the way until column
(The Machine Names) has the word End in the last row. Or until it hit
a blank sell in Column A. The End is best for me, but either will work
Once I can figure out how to get one column done I can do the other tw
columns (F, G (High, Low are the word in row one respectively))

Did that make a bit more sense

--
Message posted from http://www.ExcelForum.com