Posted to microsoft.public.excel.programming

Claus[_3_] Claus[_3_] is offline

external usenet poster

Posts: 40

Wait less than a second

Hi

I would like to delay the hiding of 4 columns, someting like

Columns("R").Hidden = True
Application.Wait (Now + TimeValue("0:00:01"))
Columns("S").Hidden = True
Application.Wait (Now + TimeValue("0:00:01"))
Columns("T").Hidden = True
Application.Wait (Now + TimeValue("0:00:01"))
Columns("U:").Hidden = True

How do i define a time less than a second ?

Hoping for an answer

Regards,
Claus

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
sendkeys(keys,wait) how do I use wait	MM	Excel Discussion (Misc queries)	1	February 11th 09 03:47 PM
Should I Wait?	Chaplain Doug	Excel Discussion (Misc queries)	0	February 6th 07 04:58 PM
.wait for 1/2 a second	Brad	Excel Programming	18	June 9th 05 03:44 PM
is there a code to wait?	choice[_2_]	Excel Programming	1	January 8th 05 06:47 AM
wait	Eddie[_4_]	Excel Programming	3	November 15th 03 03:37 PM

All times are GMT +1. The time now is 06:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us