Emece

Posts: n/a

Macro to omit blank cells needed

Is there a way to omit blanks when validating data from a list?

I am using a list that have blank cells in it, and when using this list in
other sheet I don't want this blank cells to be displayed.

I guess I should use a macro to do this, but canÂ´t figure it out. Any help
would be aprreciated.

Thanks in advance

Emece.-

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro that copy page to page just some filled cells	LC	Excel Discussion (Misc queries)	0	May 13th 05 11:22 PM
How can I make the graph omit blank cells in the data set?	easy	Charts and Charting in Excel	3	March 17th 05 02:48 PM
how to skip the blank cells	nayeemoddin	Excel Discussion (Misc queries)	1	December 6th 04 07:07 AM
copy blank cells	Vicneswari Murugan	Excel Discussion (Misc queries)	1	December 1st 04 02:12 PM
copy blank cells	Vicneswari Murugan	Excel Discussion (Misc queries)	0	December 1st 04 03:33 AM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us