I don't think you can have a leading minus in the first cell.
Before
Offset = -.Cells(1, 8) + .Cells(1, B)
After
Offset = .Cells(1, 8) + .Cells(1, B)
Or is that suppose to be
Offset = 1 -.Cells(1, 8) + .Cells(1, B)
I don't think you can have a leading minus in the first cell.
Before
Offset = -.Cells(1, 8) + .Cells(1, B)
After
Offset = .Cells(1, 8) + .Cells(1, B)
Or is that suppose to be
Offset = 1 -.Cells(1, 8) + .Cells(1, B)
Last edited by Tinbendr; 01-28-2016 at 04:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks