View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default Managging some ranges

Hi, I want to perfor as very easy operation:
For a = 5 To ActiveSheet.Range("A1",
Range("A65535").End_(xlUp)).EntireRow.Count
Cells(a, 6) = Cells(a, 7)
Next
this is for all my worksheet, but if I want the user choose a specific
region with the mouse and the program execute the same macro but just with
the selected region, How?
I mean, if the user select the range("f7:f25") then the limits of the for
structure are 7 and 25, How to accomplish this???
TIA