View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Isis[_2_] Isis[_2_] is offline
external usenet poster
 
Posts: 51
Default Process all cells in a (user) selection - vba

I am using this code to give me cell by cell access to a code defined
selection;

Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
Next aCell

which processes every cell in the A4:A34 Range

How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?

Thanks