Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to fill cells
I have a macro that clears an area "A1:Z100" of text. I would like to
add to it. How do I fill these cells with a single blank space without doing a copy/paste? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to fill cells
First, I think that this is a bad idea.
If you ever use formulas like: =if(a1="","something","another thing") then these will all break. You may need to change to something like: =if(trim(a1)="", ... It could also break up any =counta() formulas and even how navigating the worksheet (with End|UpArrow techniques). But if you want... activesheet.range("a1:z100").value = " " (I wouldn't do this!) On 08/19/2010 00:46, Fan924 wrote: I have a macro that clears an area "A1:Z100" of text. I would like to add to it. How do I fill these cells with a single blank space without doing a copy/paste? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Macro to Auto fill Cells | Excel Programming | |||
macro to fill blank cells | Links and Linking in Excel | |||
Selecting all cells of a certain fill (interior) colour (macro?) | Excel Programming | |||
Use Autofill in a macro to fill blank cells until next text - | Excel Programming | |||
A macro to fill in the blank cells | Excel Programming |