Tag Archives: Excel

Excel Sheets Navigation

Each of us who are using M.S. canada generic viagra Excel knows that we can activate a different sheets in a workbook by clicking its sheet tab left side bottom of the workbook. Many of us also know that you can press Ctrl-Page Up to activate the previous sheet, and Ctrl-Page Down to activate the […]

Posted in Excel, Uncategorized | Tagged | 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 […]

Posted in Excel, Uncategorized | Also tagged | Leave a comment