Posted to microsoft.public.excel.misc

Purnima Sharma

Posts: n/a

macros

I have designed a macro where it replaces cetain value in one column with
something. My problem is that the code works untill it reaches a space(null
value). How can I loop it so that it will ignore the null values and change
all the column values to the end of file. Thanks.

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
sharing macros	fabulousk	Excel Discussion (Misc queries)	3	March 7th 05 10:05 PM
Enabling macros	Peter M	Excel Discussion (Misc queries)	3	February 7th 05 10:57 PM
Transferring toolbars and macros to other computers	Darrell	Excel Discussion (Misc queries)	1	January 19th 05 12:21 AM
The available macros list in XL; how to suppress filename from showing	KR	Excel Discussion (Misc queries)	1	January 10th 05 07:20 PM
Macros disappear after a file is imported	Brent E	Excel Discussion (Misc queries)	1	December 18th 04 12:25 AM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us