How to fill up blank cells by copying from cell above

Lady_82

New Member
Joined
May 25, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Dear Sir/ Madam

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.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Lady_82

New Member
Joined
May 25, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Board!

There are easy ways to do that with or without VBA.
Have a look here: Fill Blank Cells in Excel Column
Dear Joe4,

thank you for your prompt response. I will look into the file you shared. I am trying to automat a file by running a series of macro programs and for that purpose i want marco to fill the blanks to proceed with the next step in the macro. I hope that make sense sorry i am new to all this!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,820
Office Version
  1. 365
Platform
  1. Windows
thank you for your prompt response. I will look into the file you shared. I am trying to automat a file by running a series of macro programs and for that purpose i want marco to fill the blanks to proceed with the next step in the macro. I hope that make sense sorry i am new to all this!
Yes, the link I provided shows a few VBA solutions that you should be able to incorporate into your project.
If you have any issue adapting them, please post back here with more details, and perhaps a sample of your data so we can see what it looks like.
 

Lady_82

New Member
Joined
May 25, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Yes, the link I provided shows a few VBA solutions that you should be able to incorporate into your project.
If you have any issue adapting them, please post back here with more details, and perhaps a sample of your data so we can see what it looks like.
Dear Joe4,

can you also explain to me how can I use the "use relative reference" feature in VBA. Thank you so much!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,820
Office Version
  1. 365
Platform
  1. Windows
can you also explain to me how can I use the "use relative reference" feature in VBA. Thank you so much!
That appears to be an entirely different question, and as such, you should post it in a new thread, so it appears as a new unanswered question for all to see.
I would recommend adding more details, explaining exactly what exactly you are trying to do in VBA with it.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,821
Messages
5,766,639
Members
425,364
Latest member
jstubs99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top