Greetings to all,
I would like to thank people in advance for any help that may be given
I am very grateful! Here is my problem: I have a list of units wit
data next to them. So far, all that I am trying to do is to go throug
each of these units and select a range of data next to it. I can ge
the macro to select the range of data for the first unit. The loo
should go to the next unit and copy the same range of data as the on
above. However, this does not happen at all. Any help is REALL
appreciated! Thank you

Sub Unit_Hourly_Updates()
Dim Unit As Variant
Unit = Sheets("UHU").Range("B7:B24")
For Each Unit In Sheets("UHU").Range("B7:B24")
Sheets("UHU").Activate
Range("C7:G7").Select
Next Unit
End Su

--
oakma
-----------------------------------------------------------------------
oakman's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=52565