Thread: Fill Down
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Fill Down

="C:\Documents and Settings\User\My Documents\Pictures\"&ROW(A1)&".jpg"
copy down


"Freddy" wrote:

Sorry, sent the previous message incorrectly.

I would like to fill down so only one character changes sequentially, like
this:

C:\Documents and Settings\User\My Documents\Pictures\1.jpg
C:\Documents and Settings\User\My Documents\Pictures\2.jpg
C:\Documents and Settings\User\My Documents\Pictures\3.jpg
C:\Documents and Settings\User\My Documents\Pictures\4.jpg

Any assistance is appreciated.