View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ArthurJ ArthurJ is offline
external usenet poster
 
Posts: 32
Default Trapping error with dynamic range

I have a dynamic range on my worksheet that expands (or contracts) to include
the data in a column. I have VBA code that utilizes this dynamic range. But
if there is no data in the column, the code generates an error ... apparently
there is no range object at all in this case. Other than general error
trapping methods, is there a more direct way to test whether the dynamic
range exists?