Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a user input string as part of the name of a range
Hi I'm building a macro where I want to use part of a string input by a user as the name of a named range. The user can put anything in the string - the strings are used as the column headers of the output of the macro. As part of the macro I need to define a number of named ranges. I would...- jlt199
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Formula written in Macro not evaluating
Hi, this is my first time on this forum. I've been muddling through with building macros in Excel, but have found a problem I can't solve. My macro opens a new workbook, reads in and sorts/filters data from a text file before analysing it. I've input a formula into cell using the macro, but...- jlt199
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
