Hi there,
I'm using the following code as part of a macro in one of my sheets, to record information from one worksheet into another:
Sub LogTaskComplete(ByVal taskName As String)
Dim currentSheet As String
currentSheet = ActiveSheet.Name
Worksheets("Log").Activate
Application.EnableEvents = false
Rows(TITLE_ROW+1).Insert
Cells(TITLE_ROW+1, LOG_TASK_COL).value = taskName
Cells(TITLE_ROW+1, LOG_DATE_COL).value = Now()
Application.EnableEvents = true
Cells(TITLE_ROW+1, LOG_TASK_COL).Font.Bold = False
Cells(TITLE_ROW+1, LOG_DATE_COL).Numberformat = "h:mm a EEE mmm d, yyyy"
Cells(TITLE_ROW+1, LOG_DATE_COL).Font.Bold = False
Worksheets(currentSheet).Activate
End Sub
After running the code, the changes are invisible in the workbook. When I switch tabs within Zoho Sheet to the "Log" worksheet, it is as though nothing has changed (except the line showing the first three rows are frozen is invisible).
The data appears to be stored correctly - because if I reload the whole sheet (by reloading the browser window, or closing the browser tab and opening the Zoho Sheet again) all the data is there. The only way to see any of the newly added data without reloading the page in the browser is to change the font colour or background colour of cells in the "Log" worksheet. I am using Firefox version 87.0 (64-bit).
Is there an extra line I am missing in my VBA code to refresh the screen? Or is this a different problem?
Many thanks,
Victoria