can the following code be written in one line?
Sheets("SC-Author ranking").Cells(j, LastColumnSc + 7) = Sheets("Author ranking").Cells(k, LastColumn - 4) - Sheets("SC-Author ranking").Cells(j, LastColumnSc - 2) If Sheets("SC-Author ranking").Cells(j, LastColumnSc + 7) = 0 Then Sheets("SC-Author ranking").Cells(j, LastColumnSc + 7) = ""
Bookmarks