JCstdio's questions

I am trying to do a very simple operation, which is to copy a data from one cell to another in excel by vba. The thing is that they are large numbers, and when inserting the value in the cell, it rounds off the last digits.

For example: 1234567891234567 transforms it into 1234567891234570

Does anyone know why?

Thank you very much.

I am trying to find a way to put an autofilter on an excel table. By default I can put the current, past and next week filters.

But what I want to do now is that I can take the week number of a cell and filter the date field of the table by that week number.

Thanks.

I am working with vba for data processing within excel, I have some reports, each one on its own sheet, in which I need to fill in the cells that are blank with the value of the cell above them.

The problem is that when I finish the first sheet, it gives me a 1004 error, and I would like it to go past that error, and continue with the next sheet. The code I have is the following:

Function structure_sheets()
    With ThisWorkbook
        For Each Sheet In .Sheets
            If (InStrRev(Sheet.Name, "Node") > 0) Then
                LastRow = Sheet.UsedRange.Rows.Count
                With Range("A8:F" & Range("F" & LastRow).End(xlDown).Row)
                    .SpecialCells(xlBlanks).FormulaR1C1 = "=R[-1]C"
                    .Value = .Value
                End With
            End If
        Next
    End With
End Function

And the error:

OnErrors don't seem to work with these blocks of code.

If anyone has an idea, suggestions are welcome.

Thank you very much.