Formula FAQ - Urgent

[nateshk]

Hi ,

Iam using VBA in Excel. In one of the sheets there is a formula used in a cell which is as shown below :

='C:\Natesh\Projects\CRMS\Risk\Existing\[VAR Positions.xls]58'!$IB$87

and also another cell formula which goes as

='C:\Natesh\Projects\CRMS\Risk\Existing\[VAR Positions.xls]MMK'!$IB$87

I cannot figure out what 58 and MMK and i have checked there are no sheets by that name in C:\Natesh\Projects\CRMS\Risk\Existing\[VAR Positions.xls


Plz help me out.

Thanx in advance.

Natesh

 

[Simmy]

Hi Natesh

Basic stuff, but these sheets are not "well hidden" by VBA code are they.

Regards

Simmy

 

[nateshk]

Hi Simmy ,

Incase these sheets ( [VAR Positions.xls]58 and [VAR Positions.xls]MMK ) are hidden , how do i view them.

Those sheets are being used in another excel sheet, so when iam opening the second excel sheets it gives a message asking me to map 58 and MMK to some existing sheets in VAR Positions.xls workbook.

Thanx and Regards

Natesh