I did that to avoid the headings row being included in the re-organisation.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"hamster" wrote in
message ...
Sorry Philip,
To make myself more clear I changed the following lines:
sTemp = Range("A1").Value & Range("B1").Value -- was A2
iStart = 1
-- Was 2
For i = 2 To iLastRow
-- Was 3
The number you start with here determine the row it starts the
formula?
ie, the values here assume the data starts on the first line?
Either way, this has been a massive help and thank you! :)
--
hamster
------------------------------------------------------------------------
hamster's Profile:
http://www.excelforum.com/member.php...o&userid=28706
View this thread: http://www.excelforum.com/showthread...hreadid=483903