$$Excel-Macros$$ VBA online interface

2014-02-10 Thread Pavan Valluru
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

$$Excel-Macros$$ VBA Password

2014-01-16 Thread Pavan Valluru
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

$$Excel-Macros$$ Interactive charts

2013-12-19 Thread Pavan Valluru
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

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

2013-11-30 Thread Pavan Valluru
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

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

2013-11-13 Thread Pavan Valluru
: ctrl+P *Warm Regards,* *Ravi Kumar.* *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Pavan Valluru *Sent:* Wednesday, November 13, 2013 12:34 PM *To:* excel-...@googlegroups.com javascript: *Subject:* Re

$$Excel-Macros$$ Reverse an Array

2013-11-12 Thread Pavan Valluru
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

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

2013-11-12 Thread Pavan Valluru
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,

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

2013-11-12 Thread Pavan Valluru
*Warm Regards,* *Ravi Kumar.* *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Pavan Valluru *Sent:* Wednesday, November 13, 2013 12:05 PM *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ Save as PDF

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

2013-09-27 Thread Pavan Valluru
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

$$Excel-Macros$$ Diemsion in a array

2013-08-26 Thread Pavan Valluru
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

2013-08-22 Thread Pavan Valluru
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

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

2013-05-20 Thread Pavan Valluru
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?

$$Excel-Macros$$ Increasing Macro Performance

2013-05-15 Thread Pavan Valluru
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

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

2013-05-15 Thread Pavan Valluru
gawlia...@gmail.comjavascript: wrote: Dear Pavansai, Share the workbook with us. Warm Regards, Gawli Anil. On Wed, May 15, 2013 at 1:57 PM, Pavan Valluru pavansai...@gmail.comjavascript: wrote: Hi There, This is pavan. Im a Financial Modeler. I need VBA in My work. Now