Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
microsoft.public.excel.programming
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Message from discussion Fill cells
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
David McRitchie  
View profile  
 More options Jul 10 1999, 3:00 am
Newsgroups: microsoft.public.excel.programming
From: dmcritc...@aol.com (David McRitchie)
Date: 1999/07/10
Subject: Re: Fill cells
Print | View thread | Show original | Report this message | Find messages by this author
Hi Bill,   (posted with email copy to bill and werner)
A couple of minor corrections to Werner's untested macro.  On the Next
statement and a test that cell to be filled is not in Row 1 of spreadsheet.  

Sub fill_empties()
'  Subject: Re: Fill Cells
'  From: "Werner Janz" <NOSPAMwerner.j...@primus-online.de>
'  Newsgroups: Microsoft.public.Excel.programming
'  Date: Sat, 10 Jul 1999 13:30:13 +0200
Dim cur_rng As Range
  For Each cur_rng In Selection
    If IsEmpty(cur_rng) Then
       If cur_rng.Row > 1 Then
        cur_rng.Value = cur_rng.Offset(-1, 0).Value
       End If
    End If
  Next cur_rng    'corrected from posting, also added row 1 test
End Sub

I have a similar macro that will not pull down  values from out of range.
  http://members.aol.com/dmcritchie/excel/fillempt.htm
Also see related area on fillempt.htm page.

HTH,
David McRitchie
My Excel Pages: http://members.aol.com/dmcritchie/excel/excel.htm  

>From: "Werner Janz" <NOSPAMwerner.j...@primus-online.de>
>bill g <su...@worldnet.att.net> schrieb in im Newsbeitrag:
>> In VBA, how do I code so that a macro will copy a cell contents to fill in
>> the rows before the next text. For example: [clipped]


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google