stack space

Hi All, I created a program for easy data entry and searching of records in MAC Excel 2011 VBA. When testing on a MAC, after playing around with adding records, then going onto the search module and back, the error of out of stack seems to creep in. I tried debugging and found that the...

Hi, I'm very new to VBA and trying to experiment with new macros. I have recorded a macro and saved into my Personal.xlsb workbook because I would like to use on many worksheets in the future. This code below is to save all my worksheets in the workbook as new files. It works when I have the...

Hi, i have the following macro which calculates the hours worked, money earnt and holiday pay accrued per month in a summary table, by using the month function on the date of each shift and adding up all the values from each month!! Sub ross() Dim i As Integer Dim n As Integer...

Hi, I have a code which enters today's date in a cell when any changes are made on the sheet. There are 5 sheets, all with the same code. Since I introduced this code I get a 'Stack Space' issue. Do I need to restrict the sheet range to use less memory? Static Sub Worksheet_Change(ByVal...