• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to fill up blank cells by copying from cell above

Lady_82

New Member
Dear Chandoo,

I need some assistance in VBA. I am new to VBA and programming and I'm trying to auto fill blank cell/s from cell above the empty cell. However, I am not able to get the instruction correct. can you please help me.
Basically I have a work book that consist of data but some cells are empty.
 

vletm

Excel Ninja
Lady_82
Fact: Total number of rows and columns on a worksheet are 1,048,576 rows by 16,384 columns.
Do You really would like to fill blank cells?

What kind of instructions do You have?
 

Lady_82

New Member
Hi Vletm,
thank you for your response.

I imported a file from text to excel and it has some monthly data for monthly sales for month of May. However, each category has name but not replicated to each row and i want auto that step in marco to proceed with other following steps. Do I make sense to you sorry i am new to VBA! thank you once again.
 

Marc L

Excel Ninja
Hi Lady !​
According to any forum rules, you forgot to post a link on every other forum where you have created the same thread​
so this is considered as a wild cross posting !​
 

vletm

Excel Ninja
Lady_82
Example
... if You have letter a in Your sheet's cell A1
... You wrote to copy 1,048,575 a -letters in A-column below cell A1

Cross-posting
> read those Forum Rules, there are clear sentences - what to do?
 
Top