setting default values within a specified range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

judoist - 15 Jun 2004 17:42 GMT

Does anyone know how to set a default value within a specified range?
I have a database with columns of single figures and blank spaces her
and there. Is it possible to instruct Excel to enter a value of -1 fo
every blank space it meets within the range A1:G250

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Frank Kabel - 15 Jun 2004 18:26 GMT

Hi
only possible with VBA (using an event procedure). Would this be a
feasible way for you?

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Does anyone know how to set a default value within a specified range?
> I have a database with columns of single figures and blank spaces

here

> and there. Is it possible to instruct Excel to enter a value of -1

for

> every blank space it meets within the range A1:G250?
>
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

judoist - 15 Jun 2004 19:53 GMT

Unfortunately not...

Thanks anyway

Nathan

---
Message posted from http://www.ExcelForum.com/

Reply to this Message

Dave Peterson - 15 Jun 2004 23:40 GMT

If this is a one time thing, you could:
select A1:G250
edit|goto|special
blanks
type -1
hit ctrl-enter

And the empty cells in that selection will be filled with -1.

> Does anyone know how to set a default value within a specified range?
> I have a database with columns of single figures and blank spaces here
[quoted text clipped - 3 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message