View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
[email protected] glimmer23@yahoo.com is offline
external usenet poster
 
Posts: 18
Default Conditional Formationg Macro

ah yes - i messed up there hehe fixed that now though... was using the
macro sheet name rather than actual sheet name (been long day)

anyways stepping into the code now getting a "type mismatch" (error 13)
error on:

With rCell.Resize(sh.UsedRange.Rows.Count).Font

could this be because the data is not continous down the column?