View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
 
Posts: 65
Default More insert rows

Hi,

I have a range of data which I have sorted in currencies in the middle of a
worksheet. i.e their is stuff below and above, with an empty row top and
bottom. .i.e

..... K L M

data...

EUR
EUR
USD
USD

more data

Im trying to insert 3 rows between each currency, sometimes there is many
sorts currencies. I can set and activate the range and find the active last
cell in the range of collumn L, but when I try to adapt a macro things just
go weird

Thanks in advance


Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1