Dear Member,
Kindly Share your Cell Number also with ur Issue for immediate
resolution.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyti
not getting u completely.plz elaborate or share ur number
On May 21, 8:17 pm, muralidhar e wrote:
> 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 gi
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 use
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
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 wrote:
> Hello,
> I have 2 sheets. In one sheet I have a dump data where I will fil
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
>
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
To: MS EXCEL AND VBA MACROS
Sent: Fri
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 date
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 impor
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.
--
--
Hello Team,
Please help me.
Thanks and Regards
Atul Kesaria
On Fri, May 21, 2010 at 9:35 AM, Atul Kesaria wrote:
> 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
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 wrote:
> Dear All,
> We are here in this beautiful group,where every one is giving the
> Helping Hand to Others
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. whenever
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
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 y
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 bet
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 th
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
__
Plz go through below given web Page for better understanding
http://support.microsoft.com/kb/214142
On May 20, 3:14 pm, Venkatesan c wrote:
> Dear Group,
>
> Any send me with example Multiple conditions Lookup
>
> --
> ---
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 wrote:
> Dear All,
>
> Please help me to provide a macro code for selecting a variable range.
>
> Suppose for example the data enter fro
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
--
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 benefi
22 matches
Mail list logo
