Thread: length of line depending on the value of the cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default length of line depending on the value of the cell
Hey Don

Very nice, neat code, although the OP requirement was if A1 has the value of
1 then B1 will have a line.

Your code places a line under A1 when the value is 1 instead of B1.

Cheers
Mick.


Reply With QuoteReply With Quote