New answers tagged microsoft-excel-2010
0
votes
Excel 2013: VBA to copy formula from one cell to the next
Function CountAndAdjustBrackets(formula As String) As String
Dim openBrackets As Integer
Dim closeBrackets As Integer
Dim i As Integer
' Count the number of opening and closing ...
0
votes
Accepted
How can I list the names of various sheets in a "recap" summary sheet in Excel?
I think that the easiest way is to write a UDF function in VBA, which can then be called in a worksheet. Its argument is the position number of the worksheet in the workbook, that is, the number 1 is ...
Top 50 recent answers are included
Related Tags
microsoft-excel-2010 × 4705microsoft-excel × 3388
worksheet-function × 1641
microsoft-excel-2007 × 727
vba × 516
charts × 242
macros × 180
pivot-table × 154
microsoft-excel-2013 × 144
conditional-formatting × 110
microsoft-excel-2016 × 77
vlookup × 74
microsoft-office × 73
csv × 73
spreadsheet × 71
windows-7 × 68
sorting × 38
formatting × 36
date-time × 32
data-validation × 32
keyboard-shortcuts × 30
windows × 28
countif × 28
colors × 25
microsoft-word × 24