How can I convert a range to a string (VBA)?

What is the best way to convert a range of cells to a string? I have a function that only takes a string as input so I need to convert the range to a string, while retaining as much of the formatting as possible (i.e. it needs to look like a table or...
more »

2017-01-21 11:01 (2) Answers

VBA pivot table run time error 5

I opened this same document on my wife's computer (excel 2016) and recorded the macro in which I created a pivot table. When I open the original version of the same document and run this macro on my computer (excel 2011) it gives me the "Run Time Err...
more »

2016-11-27 19:11 (0) Answers