Dear All,
We are here in this beautiful group,where every one is giving the
Helping Hand to Others.
Really Appreciated,I want to add just little,Some persons will at very
great position,they
can help To Give More Efforts.
Please post the job requirements,so that members of our group can be
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge.
Can you please help me.
Thanks and Regards
Atul Kesaria
--
Use this Code
Sub range()
R = Application.WorksheetFunction.CountA(RANGE(A1:A65536))
RANGE(A1:B R).Select
End Sub
On May 19, 2:40 pm, SANJAY SONI sanjaysoni2...@yahoo.co.in wrote:
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for example
Plz go through below given web Page for better understanding
http://support.microsoft.com/kb/214142
On May 20, 3:14 pm, Venkatesan c venkat1@gmail.com wrote:
Dear Group,
Any send me with example Multiple conditions Lookup
--
the technique itself is fairly simple.
the biggest issue is identifying which rows to move to which sheet.
You said that the account number is in column a.
is it in ALL rows for the record?
if you can give me a sample of data, I can help put it together for you.
Paul
Hi Paul,
Thanks so much for your reply and i really appreciate you help on the
fomula break up.
I have few questions below:
Why is this (-1)^ and ())*10+11* mentioned and what is it essential for?
Actions?
Is there a similar fomula which does the same?
It will be a great help if you help on
I have a few questions.
What version of Excel are you using?
You said in step 6, you cut the records that AG is null
did you really man cut, as in: removed from sheet1?
also, you're writing a file with :
a.WriteLine s1 s2 s3 s4 s5 s6
but the values have no spaces or delimiters between
these are mathematical operators.
do you understand mathematical operators and their precedence?
meaning: exponents process before multiplication and division,
which process before addition/subtraction.
parenthesis are used to force operations to perform in a specific order.
I have no idea what
Found example was able to modify to get to work. I am quite sure it
can be improved but
this works to find first group.
Function TestRegExp(myPattern As String, myString As String)
'Create objects.
Dim objRegExp As RegExp
Dim colMatches As MatchCollection
Dim RetStr As String
Hello,
I have 2 sheets. In one sheet I have a dump data where I will filter based
on requiremets(only first colounm i.e, country is only one filter - not
multi filter). In the second sheet I used subtotal formula to get some
fields SUM. For eg. In sheet1 I have country names coloumns.
Yes Shyam, this is a great helpful for those who are looking Job on
VBA
and thanks for all moderators who are helping people a lot.
regards,
Naniram
On May 21, 12:45 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear All,
We are here in this beautiful group,where every one is giving the
Hello Team,
Please help me.
Thanks and Regards
Atul Kesaria
On Fri, May 21, 2010 at 9:35 AM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge.
hai friends,
This is murali when iam entering the Batches or numbers(values) in a column
it should be repeat more than one time, i want the sum for entering the
values. plz help and give a solution for me. iam using office 2007.iam also
attaching a file for easy understand.
--
I get an error when I compiled this code:
Option Explicit
Option Compare Text
Option Base 0
Public Type vbA
zAs() As vbA
End Type
How can I have a list of elements vbA under my type vbA?
Lars
--
--
Some
Hi Paul -
Thanks for the reply. Let me attempt to answer your questions and
hopefully clarify a bit.
1. I am using Excel 2003
2. All of the steps prior to the code I already had were serving only
one purpose. I want to write the text file using only rows where the
date in column T equals the
did you look at my code?
if you change
StrDelim = |
to
StrDelim =
it should do what you want.
if you don't NEED to copy the records where T and E are different, you can
comment out that section.
Paul
From: Erick C boricua2...@gmail.com
To: MS EXCEL AND VBA
There is one vacant position for Tech Lead at McKinsey Gurgaon.
Interested people can apply.
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Fri, May 21, 2010 at 7:08 PM, naniram 06n...@gmail.com wrote:
Yes Shyam, this is a great helpful for those who are looking Job on
VBA
Below Code may help u
Do
ActiveCell.Offset(1, 0).Select
Loop Until Rows(ActiveCell.Row).Hidden = False
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Fri, May 21, 2010 at 6:46 PM, Vinu vinu1sm...@gmail.com wrote:
Hello,
I have 2 sheets. In one sheet I have a dump
Keep in mind that we are not moderators. We are contributors.
The moderators ensure that the contributors follow the guidelines for the
group, and violators (like sending spam, or insulting) are banned from the
group.
In my own personal opinion, this is NOT the group for posting job openings.
what error?
just looking at this, i can see how using zAs() as vbA would be a problem.
because you shouldn't use the Type to define the Type.
Like: you shouldn't use a word to define itself.
also, I wouldn't suggest using vba as a type.
the term vba has it's own definition.
IF microsoft uses VBA
20 matches
Mail list logo
