Use this :
Function CountThem(rngString As Range) As String
Dim VarArr
Dim ArrRes
Dim varWhattoFind
Dim lngCountAs Long
varWhattoFind = Array("Actor", "Businessman", "Athlete", "Dancer")
VarArr = Split(rngString.Value, ",")
For lngCoun
Maybe this will help?
http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/
On Friday, July 20, 2012 3:56:22 PM UTC-5, debdarshan wrote:
> hey! good work...
>
> i have a question
>
> How to display the
>
> *Format > Shape Style Gallery*
> **
> **thro
This is my first time to atempt anyting like this but would like to create
a Vessel Calendar that will take a set of values from a table and then draw
pentagons on a worksheet to represent the vessels on a calendar. The end
Calendar will look something like this, which we do manual now. Also
a
Basically the key thing to understand is the groups of contiguous
non-empty cells in the parent range.
On 7/29/12, Sam Mathai Chacko wrote:
> Prince,
>
> First of all, let us get the idea of an Area correct. An Area is the
> number of clusters of contiguous cells in a range. By cluster I mean a
>
Prince,
First of all, let us get the idea of an Area correct. An Area is the
number of clusters of contiguous cells in a range. By cluster I mean a
set of adjacent group of cells.
So, for example if you have some non-empty cells in A1 to C3 and D5 to
E10, then Range(A1:E10).Areas(1).Address will
by effect you mean how other sheets are linked to that sheet by
formula, why don't you try looking at the trace dependants feature in
the formula tab of Excel.
On 7/29/12, danial mansoor wrote:
>
>
> Dear experts,
>
> i have bunch of sheets which was created by someone else,i have one input
> sh
Dear experts,
i have bunch of sheets which was created by someone else,i have one input sheet
it effects many sheets is there a way where i could see my input effects
which sheets results?.is there any easy way?navigation on every sheet is quite
hectic could any one suggest easy way or macr
Dear Excel Experts,
I could really use your help. I am trying to take a string and with VBA
code tally the number of instances of a word and then output into an excel
sheet.
For example,
String >> "People: Tom Hanks(Actor), Michael Jordan(Businessman, Athlete),
Fred Astaire (Dancer), Donald
Hi All,
I want to know more about Areas property of the range object,
If I write: Range("A1").Areas(1) it return text inside that range but i m
not able to to understand what is it. And further if we write it like
range("A1").Areas.Count or range("A1").Areas.Creator
or range("A1").Areas.Par
Thanks Pascal.
WOW!!! the code runs like a Magician Wand.
I am not aware why the last row shows as #NA (as I am not knowledgeable
to that level)
I am eagerly waiting for your 'Magic Touch' for the output of Category,
Name, Hours and EOM
Thanks once again.
Rashid
On Saturday, July 28, 2012 2:08
Mr Kishore
You are violating the forum rules and you will be banned.
This query has no relation to excel or VBA and you are posting queries in
other topics.
Regards
Ayush Jain
On Sat, Jul 28, 2012 at 7:23 PM, kumar Kishore wrote:
> hai friends,
>
> how to remove the Password of PDF file
>
> R
Mr Kumar Kishore
May I ask you start new topic instead of posting in other people threads.
Regards
Ayush Jain
On Sat, Jul 28, 2012 at 6:36 PM, kumar Kishore wrote:
> hai friends,
>
> can you do favour
>
> please find enclosed PDF file
>
> please convert to word document file.
>
>
> Thank in ad
Hi,
Links of Pdf to word Converter.
*Links of Pdf to Word Converter*
http://www.onlineocr.net/
http://www.pdftoword.com/
http://www.pdfonline.com/pdf-to-word-converter/
http://convertpdftoword.net/
http://www.convertpdftoword.org/
http://www.pdftowordconverter.net/
http://download.cnet.c
google for pdf to word
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: kumar Kishore
Sent: Saturday, July 28, 2012 8:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Forcasting for acquring New Project
hai friends,
can you do favour
p
Please READ THE RULES here
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: kumar Kishore
Sent: Saturday, July 28, 2012 8:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update graph range by referencing a cell?
hai friends,
how to remo
hai friends,
how to remove the Password of PDF file
Regards,
kishore
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
So far, you're missing Paul's help!
On Saturday, July 28, 2012 8:27:18 AM UTC+1, karthikeyan wrote:
>
> Can any one help . attach sample excel sheet.
>
> On 27 July 2012 18:53, karthikeyan sankaran <
> karthikeyansankar...@gmail.com> wrote:
>
>> Hi,
>>
>> I have a 500 files(.pdf/.xls/.txt) in one
http://www.onlineocr.net/
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Sat, Jul 28, 2012 at 6:36 PM, kumar Kishore wrote:
> hai friends,
>
>
Probably easier to just use a defined name to make it completely automatic.
Goto worksheet_1
insert>name>define
mr
refers to
=$e$1
=
graphD
refers to
offset(worsheet_1!
=INDIRECT("$d$2:$d$"&mr)
or you could probably use an offset formula to make the e1 notation unnecessary.
Don Guillett
Mic
You would need to provide a file with a table of your old and new names. Then a
macro using DIR and NAME
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: karthikeyan sankaran
Sent: Saturday, July 28, 2012 2:27 AM
To: excel-macros@googlegroups.com
Subject: $
Hi Friends,
Can any body share me forecasing templates in excel file.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and N
Can any one help . attach sample excel sheet.
On 27 July 2012 18:53, karthikeyan sankaran
wrote:
> Hi,
>
> I have a 500 files(.pdf/.xls/.txt) in one folder.How to get .pdf files
> name only in excel sheet and rename desired name what i entered in
> other column in excel sheet.
> ex: old name
I have a spreadsheet with data that gets updated weekly.
The first worsheet has the raw data.
On 4 more separate worksheets, I just have separate graphs of the data from
thefirst worksheet.
At the moment I have to update the range of the graphs by going into each
separate worksheet and changing
23 matches
Mail list logo
