Category Archives: Excel

Refresh excel formula calculations

Recheck dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since last time or not. use CTRL+ALT+F9

Posted in Excel | Leave a comment

Convert rows to cell seperated by commas

You need to add a custom function in Excel. You can add using the edit macro option in excel. Then use the below code in the macro window. Function ConCatRange(C1 As Integer) As String Dim CellBlock As Range ‘CellBlock = x1: x2 Dim cell As Range Dim sbuf As String ‘CellBlock = CellBlocks Set CellBlock […]

Also posted in Uncategorized | Tagged , | Leave a comment