I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the
cell is blank I need it to go to the nearest cell above it and copy
that number. For example

A1=443
A2=
A3=
A4=558
A5=


I would need A2 and A3 to be filled with 443 and A5 to be filled with
558. please help!

you can do this without a macro

Select the range
hit CTRL+G (Goto)
Select 'Special'
In specil window select 'Blanks'
now click on OK
Now only blank cells are selected
hit CTRL+D, this will copy the details from top cell to below blank cells only
then you can do a copy-paste special values on a safer side.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"JRB1024" wrote:

I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the
cell is blank I need it to go to the nearest cell above it and copy
that number. For example

A1=443
A2=
A3=
A4=558
A5=


I would need A2 and A3 to be filled with 443 and A5 to be filled with
558. please help!

See previous post

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JRB1024" wrote in message
ups.com...
I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the
cell is blank I need it to go to the nearest cell above it and copy
that number. For example

A1=443
A2=
A3=
A4=558
A5=


I would need A2 and A3 to be filled with 443 and A5 to be filled with
558. please help!

On Aug 21, 10:19 am, "Bob Phillips" wrote:
See previous post

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JRB1024" wrote in message

ups.com...



I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the
cell is blank I need it to go to the nearest cell above it and copy
that number. For example

A1=443
A2=
A3=
A4=558
A5=

I would need A2 and A3 to be filled with 443 and A5 to be filled with
558. please help!- Hide quoted text -

- Show quoted text -

When I hit ctr-D it does nothing.

On Aug 21, 10:28 am, JRB1024 wrote:
On Aug 21, 10:19 am, "Bob Phillips" wrote:





See previous post

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JRB1024" wrote in message

oups.com...

I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the
cell is blank I need it to go to the nearest cell above it and copy
that number. For example

A1=443
A2=
A3=
A4=558
A5=

I would need A2 and A3 to be filled with 443 and A5 to be filled with
558. please help!- Hide quoted text -

- Show quoted text -

When I hit ctr-D it does nothing.- Hide quoted text -

- Show quoted text -

What formula would you guys recommend to use?