View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajliaks[_44_] ajliaks[_44_] is offline
external usenet poster
 
Posts: 1
Default Vba excel - autofill


Hi all,

I need to fill some cells with integer numbers starting from 1:
For example, I need to fill from Cell B15 to B25 with the number
1...to 10

I am trying this:
Range("B15:B25").Select
Selection.AutoFill Destination:=Range("B15:B25")
Type:=xlFillDefault
Can anybody help, please?
Thanks,
Aldo

--
ajliak
-----------------------------------------------------------------------
ajliaks's Profile: http://www.excelforum.com/member.php...nfo&userid=819
View this thread: http://www.excelforum.com/showthread.php?threadid=27825