View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_32_] Peter[_32_] is offline
external usenet poster
 
Posts: 2
Default Using object Range dynamic???

I'm using a macro to fill a range of rows and columns in
Office 2000, se code below.

Range("A1:C1").Select
Selection.AutoFill Destination:=Range("A1:C22"),
Type:=xlFillDefault
Range("A1:C22").Select

What I want to do is to do the fill from cell A1 to cell
(row - input from user, column C).

Input from user is stored in an Integer.

It seams like en easy problem but I havent found the
answer.

/Peter