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
|