Skip to main content

New answers tagged

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 ...
Туан Нгуен's user avatar
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 ...
MGonet's user avatar
  • 2,625

Top 50 recent answers are included