View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William William is offline
external usenet poster
 
Posts: 119
Default repeat macro through cell until first blank

I am running a macro through one specific column of my spreadsheet. From cell
B4 to anywhere from B20 or higher, to be exact. I need to add something to my
code so that my macro will execute in each cell moving down that column until
it encounters the first blank cell. At that point it should stop altogether,
doing nothing with the blank cell.

Any suggestions?