M_sgData(q, 2) = rCell.Offset(0, 7).Value ' store revenue to array M_sgData(q, 1) = rCell.Offset(0, 4).Value ' store rooms to array Range('C:C').Cells.SpecialCells(xlCellTypeConstants).Count ' populate array with rooms and revenue figures from source file X = m_wbTemplate.Sheets(3).Range('A:A').Cells.SpecialCells(xlCellTypeFormulas).Count ' size array to hold rooms and revenue figures 'ROOM ONLY', 'GOVERNMENT GROUP', 'AIRLINES', 'LEISURE GROUP', 'LONG TERM', 'SPECIAL GROUP', 'HOUSE USE', 'COMP') VSourceSegment = Array('BAR', 'DISCOUNT', 'LEISURE', 'NEG CORP', 'NEG GOLD', 'NEG GOV', 'NET ONLINE', 'FAIR GROUP', 'RESIDENTIAL', _

' create array with source file segment names ' update template with forecast or budget data from source file Set fd = Application.FileDialog(msoFileDialogFilePicker)ĭim rCell As Range, rWriteRange As Range, rSourceRange As Rangeĭim q As Integer, x As Integer, y As Integer, z As Integer ' manage source file, launch update template routine and present confirmation dialog Thanks!ĭim m_wbSource As Workbook, m_wbTemplate As Workbook

Is there an issue in my code? A potential issue with a setting on their Mac? I'm told that the client has the 'latest' version of Excel for Mac if that matters. Would certainly appreciate if someone could point me in the right direction here. In any case, the code on line 8 is the first line of code in the module, just declaring a string variable:Īnd I've placed the full code below (two subroutines contained in the same module). At first I thought there could be a missing library reference or something, but I think the error message would state such instead of just being a compile error, no? So the module is obviously called 'modPanda' and I think the '8:4' references screen coordinates for the offending code (line 8 column 4). Here is what the error message on their Mac says:Ĭompile Error: User-defined type not defined (modPanda 8:4) I've Googled this quite a bit and can't seem to figure it out. Don't have a Mac myself to test on, which doesn't help. So I've written a routine for customers, and those with Macs are not able to run it.

Define sub in excel vba on mac