$$Excel-Macros$$ VBA online interface

Is there any sites available, where we can run our vba code online? like in W3schools??? -Pavan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1)

$$Excel-Macros$$ VBA Password

Do we have VBA code to un protect or crack VBA password? -Pavan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread tit

$$Excel-Macros$$ Interactive charts

Hi Guyz, can anyone tell me can i call any macro or event once user moves the cursor to a particular series of chart? i would like show the selected series data just below the chart once user moves their cursor on a series. Can we do this using API or anything else? any ideas? Please guide me

$$Excel-Macros$$ Adding .xll into the excel file.

Guyz, Hope all are doing well. Here i need one help. can we add .xll file to the excel file and give option for the user to download it from that excel ? like Click here to download .xll. So that the user of the excel file can get .xll from the respective excel file. so i can not send 2 files f

Re: $$Excel-Macros$$ Save as PDF for 2003

ing “activesheet.printout” or by pressing : ctrl+P > > > > > > > > *Warm Regards,* > > *Ravi Kumar.* > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Pavan Valluru > *Sent:* Wednesday, November

Re: $$Excel-Macros$$ Save as PDF for 2003

book.Path & "\Filename.PDF" > > End Sub > > > > > > > > *Warm Regards,* > > *Ravi Kumar.* > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Pavan Valluru > *Sent:* Wednesda

$$Excel-Macros$$ Save as PDF for 2003

Can anyone has code to Save as PDF for excel 2003? If yes, please shares. -Pavan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, ac

$$Excel-Macros$$ Reverse an Array

Guyz Can i know how to reverse ana array in VBA. I am passing values like MyArray(1) = 1,MyArray(2) = 2,MyArray(3) = 3 But i need to reverse that array without using loop. Is there any direct function to reverse it? i need output like MyArray(1) = 3, MyArray (2)= 2 & MyArray(3) = 1. Thanks in A

$$Excel-Macros$$ Autofill while typing in a cell

Hey VBA Buddies, Hope al iz well. Here is my query. In excel , is it possible to add auto fill while typing a particular text. I have some data somewhere in excel and i am trying to add autofill function if i am typing a cell, i just want to see suggestions those words starts with the text i

$$Excel-Macros$$ Diemsion in a array

Hey guyz, can anyone tell me the maximum # of dimenstions that can be stored in a single array in VBA. I guess around 64 demensions but want to confirm with you guyz. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

$$Excel-Macros$$ Behind code of Sum function in VBA

Hi Guys, Hope all are doing well. Here comes the subject. I am trying to get the code behing sum function. I searched for the but all went vain. I tried using Paramarray but it is not working when we are refering to a paraticular range. i want to write a function which really works like sum fu

$$Excel-Macros$$ Hyperlinks to a bar in Bar Chart

Hi there, This is pavan. Have you ever been tried to assign Hyperlinks to a specific bar in a bar chart? or is it possible to assign hyperlinks to market or to data labels? all using vba? Share your experiance here. Thanks for this. -Pavan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An

Re: $$Excel-Macros$$ Increasing Macro Performance

look. >> >> >> On Wed, May 15, 2013 at 2:04 PM, अनिल नारायण गवली >> >> > wrote: >> >>> Dear Pavansai, >>> >>> Share the workbook with us. >>> >>> Warm Regards, >>> Gawli Anil. >>> >>> >&

$$Excel-Macros$$ Increasing Macro Performance

Hi There, This is pavan. Im a Financial Modeler. I need VBA in My work. Now a days i am getting models which will need macro to update huge data. Like I need to copy single data point accross 1 columns and 5000 rows. For this i used below to perform this task. 1. No Array Formulas in the W