Posted to microsoft.public.excel.programming

Teresa

external usenet poster

Posts: 169

Subscript is out of Range

Hi,

Below is an extract from a macro, why do I get 'Subscript is out of range',
many thanks

Sub yy()

Dim curWkbk As Workbook

Set curWkbk = Workbooks("wip " & Format(Date, "dd-mm-yy") & ".xls")

End Sub

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
Subscript out of Range	Steve	Excel Discussion (Misc queries)	3	April 15th 09 04:01 PM
Subscript out of Range Q	John	Excel Programming	5	December 14th 04 07:54 AM
Subscript out of range	Bill Murphy	Excel Programming	1	August 5th 04 08:52 AM
subscript out of range	Todd Huttenstine[_3_]	Excel Programming	1	June 11th 04 04:08 AM
SubScript Out Of Range.	Sam	Excel Programming	4	December 21st 03 02:10 AM

All times are GMT +1. The time now is 08:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us