View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carrie_Loos via OfficeKB.com Carrie_Loos via OfficeKB.com is offline
external usenet poster
 
Posts: 116
Default visual basic Loop by rows in Excel

I have a data range with merged cells and other cells not merged in a
spreadsheet. I want to find only the merged cells so I can store a lookup
function in them using visual basic. My problem is I can't figure out either
how to enter the function in the merged cells only and stop the loop so it
doesn't go into my titles, which are merged cells, and enter the function in
those. Any ideas?

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200801/1