Dear Deepak,
Please find attachment with solution.
Thanks,
Noorain Ansari
On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Dear all
I attached a sample file, the problem is
there are two lists one is Sales_head other is cities comes under that
sales head
my
Thank you Andy.
I insert the module but I can't see it in the list of functions
Anyhow, when I try to run it, I get the following error:
Compile Error:
Expected: line number or label or statement or end of statement.
Any clue what is it about ?
Thank you!
On Sep 18, 6:25 am, Aindril De
Hi Giorgio,
Looks like the issue was here:
*Function RandLotto(Bottom As Integer, Top As Integer, _
Amount As Integer) As String*
*
*
*When you copy paste the above it does not work.*
*
*
*Please replace the above lines with:*
*Function RandLotto(Bottom As Integer, Top
put this formula into SourceBox in the Data Validation List
=OFFSET($B$1,MATCH($E$2,$A$2:$A$17,0),0,COUNTIF($A$2:$A$17,$E$2),1)
[image: Formula for List Source.PNG]
please check the attachaed workbook
best regards,
siti Vi
On Sun, Sep 19, 2010 at 2:12 PM, Deepak Rawat deepakexce...@gmail.com
http://www.ozgrid.com/Excel/excel-interpolate-cubic-curve-fit.htm
http://www.brothersoft.com/excel-cubic-spline-16499.html
http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm
On Sun, Sep 19, 2010 at 2:04 AM, Pratik pratik...@rediffmail.com wrote:
Hi,
Can anybody help me find VBA macro to perform
Hi,
Sorry, but someone else will have to take this one.
Regards - Dave.
From: jai.ca...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column Data in Rows Table
Date: Sun, 19 Sep 2010 00:43:18 +0530
Hi Dave,
I also have the similar issue.
Name
A
B
C
Hi Pratik,
Dont know much about this, however I have googled this up for you:
http://www.business-spreadsheets.com/forum.asp?t=120
http://www.business-spreadsheets.com/forum.asp?t=120please check if this
works
Regards,
Andy
On Sun, Sep 19, 2010 at 12:34 AM, Pratik pratik...@rediffmail.com
Dave/Paul
Can you look into this one and help me.
Regards
Chandru
On Sun, Sep 19, 2010 at 5:25 PM, Chandru chandr...@gmail.com wrote:
Dear Experts
I have now obtained the code the extract text from shapes and comments
in a workbook to a new sheet with all the details of the shape
object.
Hi Friend,
You can download Excel addins from www.diddb.com,www.vertex42.com,
www.ozgrid.com,www.add-ins.com,www.ablebits.com,www.office-eccel.com etc.
For creating excel add-ins you have to be proficient in VBA Coding,writing
Macros and also you require knowledge of some excel events and
Hello,
Your answer lies in the properties of list box which are given below.
Add a list box (Form control)
1. If the *Developer* tab is not available, display it.
[image: Show]Display the *Developer*
Guys thanks for your help, things are working well now, I have formatted
date column as per your suggestions.
Hugs en Love
On Sat, Sep 18, 2010 at 3:10 PM, ALAM aftab.ala...@gmail.com wrote:
dear all
plz find an enclosed files
aftab ali
On Sat, Sep 18,
I think it would be best if you sent me a sample file.
Otherwise, I could spend hours making a file that I THINK is like what you have
only to find out that I'm not even close.
Paul
From: Chandru chandr...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, September 20, 2010 6:47:24 AM
oops, nevermind.
I think there is a file in a previous post.
I'll look.
Paul
From: Chandru chandr...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, September 20, 2010 6:47:24 AM
Subject: Re: $$Excel-Macros$$ Extract the text from Textbox and return back
after editing
Dave/Paul
Can
Let's try again.
Please post (or send) a file that contains your work so far,
and with grouped shapes.
Perhaps I can interrogate group members.
Paul
On Sep 20, 1:48 pm, Paul Schreiner schreiner_p...@att.net wrote:
oops, nevermind.
I think there is a file in a previous post.
I'll look.
Try changing the button-click macro to:
Private Sub CommandButton1_Click()
Dim R, C, RepRow, MaxRow, MaxCol
Sheets(Sheet2).Range(A2:C65000).ClearContents
Sheets(Sheet1).Select
Sheets(Sheet1).Range(A1).Select
MaxRow = ActiveCell.SpecialCells(xlLastCell).Row
MaxCol =
HI
I'm trying to find a way to monte carlo analyze for Time schedule for
project management
So if anybody could help on how to implement Monte carlo analyse in
excel for X data..
thank in advance
cheers
Steen
--
Hello Team,
Everyday I am supposed to visit http://www.goldprice.org/ and checking gold
price, then I enter gold price into an excel file. I was wondering if its
possible to automate this task. I mean create some vba that will pick gold
everday and put it into excel sheet am using. I hope am clear
My file contains various text boxes, shapes (rectangle, call out etc),
comments and grouped shapes in the second sheet that is named Original
sheet. Extraction of text is successful for the stand alone shapes and it
is not extracting the grouped items. You can find out by running the macro
named
Hi Team,
I have different files in different subfolder in a main folder. Now I
wish to collate all subfolder files to the Mainfolder. The macro has
to go inside each and every subfolder and copy the files and paste it
to a new folder.
As a result of this the all files has to be pasted in one
19 matches
Mail list logo