View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Michiel via OfficeKB.com Michiel via OfficeKB.com is offline
external usenet poster
 
Posts: 48
Default Option Explicit is ignored

I simplified the code since it was a lot of code.

But in this example it still occurs.

I searched for the variable in other modules but it is not found anywhere

M.

-------------------

Option Explicit
'Constants to define where the columns of interest are in the input file
eSec_Blackrock_SSB 9_10 Breakdown.xls
Const cBAssetCat = 1
Const cBAccount = 2
Const cBCusip = 8

'Constants to define where the columns of interest are in the input file
Security Valuation.xls
Const cVRepAccNo = 1
Const cVMellonSec = 7
Const cVShpPar = 16
Const cVLocalPric = 24
Const cVLocMV = 26

'Constants to define where the columns of interest go in the output report
Const cRRepAccNo = 1
Const cRAssetCat = 2
Const cRMellonSec = 3
Const cRShpPar = 4
Const cRLocalMV = 5
Const cRPArxLocMV = 6


Sub MakeReport()
lngLastSectionRow = ActiveCell.row
Msgbox lngLastSectionRow
End Sub



-------------------

Don Guillett wrote:
As ALWAYS, post your code

Anyone can shine a light on this please?

[quoted text clipped - 11 lines]

M.


--
Message posted via http://www.officekb.com