I have program like this
[code/]
Public Function aUnit(Element As Integer)
aUnit = Array("AA", "AB", "AC")(Element)
End Function
Private Sub Refresh_Click()
For nLoop = 0 To nMaxUnit
cUnit = aUnit(nLoop)
For nCol = 21 To 25
For nRow = 8 To nMaxRow...
Thanks TonyJollans, PH and Geoff
Tony's code can solve it.
In my excel I have workbook's code and user form's code. I put public function aX in workbook's code but form's code can not recognize it...
so where should I put public function aX ?. or I have to make both in workbook's code...
My program like this.
Option Explicit
Public aX(4) as string
aX = array('sheet1','sheet2','sheet3','sheet4','sheet5')
----------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
For nLoop = 0 To 4
cX = aX(nLoop)
Sheets(cX).Visible = xlVeryHidden...
RR
I am using syntax (file("C:\TEMP\NUL")) to check that directory "c:\temp" exist or not, in windows XP didn't work. can anyone help me, please....
TIA
Rob.
there is error when compile :
wmake /f doswat.mak PLBNAME=curdrive MODEL=1
the error is :
This is an OS/2 32-bit executable
I am using win XP and I've tried at win 98 too.
TIA
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.