Search results

Just for giggles, did try disabling any other addin's you have enabled and try rerunning the code.

this should be pretty easy. can you post a sample?

http://msdn.microsoft.com/en-us/library/office/ff196165.aspx

ha! good call

any forum that lists me as a notable member can't be very good.

how are you determining the cells?

I would think power query would do this with ease?

what version of excel?

Depends on your definition of "option":) Typically, I think people generate a log file to track changes.

To do what?

I don't think there's anything that would help with that but with 15-20 concurrent users I'd suggest that Excel isn't the right answer. Access or sharepoint maybe?

that's pretty slick. but please don't post live data.

what's the 6th column? There's a loop at the end of it that puts the data back into an array so you can output. First line is For i = 2 To coldoctors.Count, change the 2 to a 1.

also!! in a class you can go me.property to do stuff---- so like me.price * me.qty which is pretty much the cat's pajamas.

Aha! It's a reference to Microsoft Calendar control 2007 which is not present on my win7/office 2013 thing. But it's in my xp/07 vbox. I'm still not clear on what you're trying to do. But, I think whatever it is will be much easier if you database your information on another worksheet and...

a1 is empty. Why would you want to copy something and paste it in the same place?

I get "can't find project or library". What version of excel is this for?

I think we need a little more information on what you're trying to do. Otherwise: Sub copy() Dim rInput As Range Dim rOutput As Range Dim aData As Variant Set rInput = Sheets("sheet1").UsedRange aData = rInput Set rOutput = Sheets("sheet2").Range("a1") rOutput.Resize(UBound(aData, 1)...

so.... select case a1 case 1 set TheRange = [range1] case 2 set TheRange = [range2] end select vlookup(b1,[therange],2,false)

from now on all of my code will show that message box......lol

Like the answer is to all broad vba questions, "it depends" What's the difference between the vlookups? Easiest way might just be a select case statement select case cell1 case 1 vlookup(a1,somerange,2,false) case 2 vlookup(a1,somerange,3,false) case 3 vlookup(a1,somerange2,2,false) case...

...............this looks most efficiently achieved with formulas.....

Villalobos, was this a leftover from the great dashboard contest of 2009?

i'm still messing with this. the slicers makes the time line easy, but I totally fail with the excel 2013 charting engine.

Naaa. You should be able to just disable it.