PDA

View Full Version : VBA script in excel! help



reddishpink
04-23-2010, 06:54 AM
Hello! I have a longggg list of data in this excel file. There are few cells that are empty.. So i need to fill in these empty cells with number 0.
The thing is each cell is divided to two rows, so only the above (first) row needed to fill with number 0. can someone teach me this? ive no clue about VBA at all!

mbarron
04-23-2010, 07:17 AM
Can you post a workbook demonstrating you structure?

tpoynton
04-23-2010, 07:43 AM
could also use replace (ctrl H) to replace blanks with 0. If there are truly only a few cases, you could eyeball each one before replacing. Otherwise, provide a sample workbook:)

mdmackillop
04-23-2010, 09:39 AM
Press F5/Special/Blanks then
0 Tab Tab
until all your blanks are filled.

Paul_Hossler
04-23-2010, 11:00 AM
In a scratch area (e.g. B1), enter 0 and then select B1 and B2, and Copy (control-C)

Select the destination range, F5, Special, Blanks

Paste (control-V) to get them all at once

Paul

mdmackillop
04-23-2010, 11:16 AM
In a scratch area (e.g. B1), enter 0 and then select B1 and B2, and Copy (control-C)

Select the destination range, F5, Special, Blanks

Paste (control-V) to get them all at once

Paul
:clap: :clap: :clap:

mbarron
04-23-2010, 11:21 AM
If I'm reading the OP correctly,the mass update would have undesirable effects.
The thing is each cell is divided to two rows, so only the above (first) row needed to fill with number 0

mbarron
04-23-2010, 11:22 AM
And if I read Paul's post correctly, I'd realize he took that into account.
:banghead: