Search results

That works. How would I go about making that array multidimensional?

Yes. I need 2. So, this is something of a prototype for a project I'm working though: I've got like eleventy gazillion rows of cumulative data. Like Month 1: 10 Month 2: 20 Month 3: 30 Month 4: 40 So---each month I added 10. The ultimate objective is to take those values, and in...

This is probably me being new to arrays: Dim MyArray(1 To 1000, 2) As Long Dim rSourceRange As Range Dim rTargetRange As Range Set rSourceRange = Range("B1:b1000") Set rTargetRange = Range("g1:g1000") MyArray = Range("b1:b1000") So ideally I want to set a range, have the array store...

I know it's a pita. If I had a dollar every time I got a phone call like: Person: "YOUR MACRO DOESN"T WORK" Me: "What's it doing?" Person: "NOTHING THATS THE PROBLEM" Me: "Did you enable macros?" I'd be rich.

Weird: I'm not getting an error. It's just not working. So ha. Error fixed, right? Anyway: indirect() returns the value of the cell you put together. So, where A6 is equal to 40, and your rowlocation is 6, doing indirect("a"&rowlocation) will return 40. I guess you could mess...

I don't think you attached it.

I don't think you can do that with a basic inputbox. You can do it pretty easily with a custom form though.

god damn muppets screw up my vba all the time.

You can set up some really, really simple vba (I'm talking like total copy/paste stuff) to refresh pivots. I've found refreshing pivot charts to be kind of difficult to manage long term. Better option: use pivot tables and set up regular charts using =getpivotdata().

try application.ontime You can set a timer to call a given function. That function can open a workbook, spit out a number, and close the workbook.

Weird. Not that it matters, but I can't get it to work with activesheet. Rather, I actually have to specify the sheet. For this project it will be fine because I'll have the sheets named pretty clearly. Thanks.

This may be simple. Here's the set up: I've 4 dynamic charts in a 'dashboard' kind of layout. The sources for the charts change based on vba. Each chart has it's own "display" flag to deal with a bunch of conditions where I won't want ot display the chart. So, no data to display, some...

Where is the macro going to be running?