View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
garlnnd garlnnd is offline
external usenet poster
 
Posts: 1
Default Need help with simple macro


Hello All,

I do not work with excel on a daily basis, I'm actually a web developer
but I have a request to modify an excel spreadsheet via a macro.

Basically I have about 20 rows. One cell in each rows has a number
,i.e. A2 is 250
A3 is 400, etc.

I need to write a macro to take that number in the A cell and copy the
row that it exists in that many times.

So if Cell A2 has a value of 250, I need to copy Row 2 250 times.

I'm pretty sure I could figure this out if I scour the web and use
trial and error, but I was wondering if someone could help me out. I
dont think the macro would be terribly difficult.

Thanks in advance,

Garlnnd


--
garlnnd
------------------------------------------------------------------------
garlnnd's Profile: http://www.excelforum.com/member.php...o&userid=27832
View this thread: http://www.excelforum.com/showthread...hreadid=473426