Hi All,
Please note that the below attachment is working fine. But when there is not
attachment, then If the cells ( Attachment & Doc ) are blank then the body
is found missing in the mail.
Please help.
Thanks & Regards,
Gurumurty Sastry K H
On 4/10/09, Subu wrote:
>
>
> It was me who shared
No use Praveen,
Some other idea?
Jitendra
On Wed, May 13, 2009 at 2:42 AM, kvc praveen kumar wrote:
> Just try =A1&B1 in C1.
>
> On Tue, May 12, 2009 at 1:27 PM, wrote:
>
>>
>> Hello,
>>
>> I have a problem in displaying AM or PM, when i try to concatenate to
>> cells. Below is the reference -
Rod,
Few facts about the code...
It (subset sum) is a well-known, well-discussed problem in the field of
computer science. It is a vast subject.
For relatively smaller lists, for example, the one in your original post,
the algorithm hardly takes less than a minute to find the subsets. For lists
Hi Dilip,
Thanks for your explanation.Great!
On Tue, May 12, 2009 at 4:59 PM, Dilip Pandey wrote:
> Hi Yu,
>
> For copy purpose, you can simply copy the formula and then you can replace
> (Ctrl +H) the "=" sign with "".
> Now moving over to your second question:-
> Ctrl + D -> it will copy
hahahaha...Ctrl+H again..hehe ,well it comes in handy:-)
On Tue, May 12, 2009 at 4:54 PM, Dilip Pandey wrote:
> Hi
>
> press Ctrl +H and replace "total charge:" with "".
>
> Thanks.
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...
to copy just the formula.. copy it from the formula bar.
Ctrl + D - to copy the cells from top to bottom (the last cell that you have
your cursor on)
Ctrl + C and CTRL +V - copy and paste "all" - which means formula,format
etc..
*Sri*
On Tue, May 12, 2009 at 12:02 PM, Yu wrote:
>
> Hi All,
>
>
Just try =A1&B1 in C1.
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B Column C
>
> 4/16/2009 9:00 AM CDT 4/16/2009 9:00
Hi ,
I think the best and efficient way to learn is to buy a Excel 2003/2007
book and come to forum a lot. That is exactly how I started one and half
year ago.
On Sun, May 10, 2009 at 2:18 PM, bathina srinivasa rao <
ask_...@rediffmail.com> wrote:
> kindly help by sending Ebook on Excel.
>
>
Hi there,
Sorry it took too long to return your reply. I really appreciate your
prompt reply. This was exactly what the person in the class needed. I
really cannot thank you enough.
Kindest Regards,
Rod Urand.
On May 8, 8:32 am, "Ajit Navre" wrote:
> Hi,
>
> Find attached the file with the s
Hi Raghu,
Little modification in your formula and it works:-
=CONCATENATE(MONTH(A1),"/",DAY(A1),"/",YEAR(A1),"
",HOUR(A1),":",MINUTE(A1),":",SECOND(A1),":",IF(A1="AM","AM","PM")," ",(B1))
File is attached as well for your quick reference.
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM
Thanks for the quick response, try the following:
1. Highlight a range of data
2. Sort by Ascending order
3. Highlight a different range
4. Now Press F4, nothing happens. In Excel 2003, F4 would have repeated the
last command, now in Excel 2007, that does not
happen.
Try it and let know if t
Hi Balla,
Please find the solution attached.
Explanation:-
Select the entire row 1 and apply conditional formatting choosig Formula:-
=ISNUMBER(MATCH("*Friday*",1:1,0))
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
i was try the cell text format.but that value is change
1100 (for 11E17) when i do it.
i know that problem is give me for scientific notation
i was write that VBA for text format but that is not work.
--~--~-~--~~~---~--~~
---
Hi
press Ctrl +H and replace "total charge:" with "".
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, May 12, 2009 at 10:20 AM, subs wrote:
>
> hi
>
> i have data like this in the column of the
Hi Yu,
For copy purpose, you can simply copy the formula and then you can replace
(Ctrl +H) the "=" sign with "".
Now moving over to your second question:-
Ctrl + D -> it will copy the data with formula and text / formatting from
above cell.
Ctrl + C and Ctrl + V, will first move the data to clipb
hen in Cell B2, you get the string
presentation of the date, now you can export to any file (xml,text) and have
the date appearance as 20090512.
On Tue, May 12, 2009 at 3:09 PM, Aindril De wrote:
> Excellent explaination Paul...
> Learnt something new today..
>
> Keep up the grea
Try making the cell text format. The prorgam is converting to
scientific notation which is why you are getting the different values.
On May 11, 1:14 pm, "2008ra...@gmail.com" <2008ra...@gmail.com> wrote:
> Hi
>
> I have a problem with my goods's code.my goods's code is that bellow
> codes and tha
The problem is your "Do While" loop isn't looping through anything!
You said "Range("B3").select
which makes Cell B3 the ACTIVE CELL.
so, even if your whole macro works, it will check to see if B3 is empty,
copy B3, then it's DONE!
next, you're jumping back and forth... select sheet1, copy the ce
Hi,
Use this formula:
=right(A1,3)
if ur cell is in A1
Let me know if this helps.
JAYAVELU
On Tue, May 12, 2009 at 3:59 PM, kvc praveen kumar wrote:
> Hi,
>
> Use this formula:
> =MID(A1,15,LEN(A1)-15)
> if ur cell is in A1
>
> Let me know if this helps.
>
> On Tue, May 12, 2009 at 10:20 A
Excellent explaination Paul...
Learnt something new today..
Keep up the great work..
Regards,
Andy
On Tue, May 12, 2009 at 7:15 PM, Paul Schreiner wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores it as a NUMBER ("4/16/2009 9:00 AM" is s
Yes, back to the original post.
the VALUE in the cell is NOT A DATE!
It is a NUMBER.
The FORMAT of the cell is DISPLAY the number as if it were a date!
I don't export to XML, so I'm not sure if there are settings that would handle
the date conversion.
what you're doing to convert the number to a
Ctrl-D:
Have you TRIED it?
Let's say you're making entries in 10 columns.
some are the same as the previous row, but some are not.
Your start on the left.. type something, hit tab to the next column,
type something, then the next column has the same value as the row above,
you hit the "up" arrow, c
Precise! Very useful !
when I export a Date (appears as a Date format) to XMl..why it appears as
a number 39919.375.any idea on that?
On Tue, May 12, 2009 at 2:15 PM, Paul Schreiner wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores
hi group of excel's members
i hope your everything be EXCELlent.
i have two sheets.that sheets name are Sheet1 and Sheet2.
i have texts in column B of sheet1 and i wanna write same texts in
sheet2 .
i was write bellow code but it is not write that texts in sheet2.
Sub WriteShe2()
Sheets("sheet
Hi Paul,
I don't wanna copy the formula, just wanna copy the text after "=".
Sometimes there is a long string after "=", and I wanna copy that string
instead of typing it at other place:) If there is not shortcut, is there
any way at all..hehe
Well, regarding Ctrl+D : If there is fo
Hi,
Please find the attached solution.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, May 7, 2009 at 11:00 PM, Sabbycat wrote:
>
> This is fairly simple question just dont know how to approach
Are you saying that you want to copy the formula WITHOUT the "=" ??
I'm not sure if there is a shortcut.
But in answer to your second question:
Ctrl-D simply copies the contents of the above cell.
Paul
From: Yu
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, May 1
First, I want to remind you that the "date/time" isn't being stored as a "date".
Excel stores it as a NUMBER ("4/16/2009 9:00 AM" is stored as: 39919.375)
But, you're using a cell format of: "m/d/yy h:mm AM/PM" (or similar) to DISPLAY
the number as a date/time.
Excel then checks the fraction of a
thanx
On Tue, May 12, 2009 at 12:50 PM, Mudassar Ramzan wrote:
> Download the following Utilities to unprotect the any excel sheet. If any
> problem found let me know.
>
>
> http://rapidshare.com/files/232001465/ExcelUtilities-including_password_breaker.rar
>
>
> *Regards,*
> **
> *Mudassar Ramz
F4 is working just as fine in Excel 2007 as it was in earlier versions.
Kindly recheck. If you changed your laptop/PC see if the function key works
with Fn key pressed.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwa
Hi,
it Simple,
Its replace method,
Open your Sheet,
Press Ctrl+F (Find) Chose "Replace" Tab
Type "Total charge" in find tab, Dont put any data in replace tab
then press "Find All" tab & Then "Replacce All"
You will find only data which you want,
Thank You,
Jitendra
On Tue, May 12, 2009 a
Select all cell which u want to remove Total Charge then
do Ctrl+H ,write " total charge" in find row and in replace it with ("
")blank.
On 5/12/09, subs wrote:
>
>
> hi
>
> i have data like this in the column of the excel table
>
> total charge: apl total charge:ppg total
Hello,
I have a problem in displaying AM or PM, when i try to concatenate to
cells. Below is the reference -
Column A Column B Column C
4/16/2009 9:00 AM CDT 4/16/2009 9:00 CDT
You see, after i concatenate Column A and Column B, in Column C, i get
the
hi
Just select the columns
then do find replace
in the find row put total charge: (keep in mind to put the space)
in the replace put blank
regards
aditya
- Original Message
From: subs
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, 12 May, 2009 10:20:21 AM
Subject: $$Excel-Macros$$ de
Maybe I got it wrong. But if I understand correctly, then you can use the
following code at the end of the loop ( when your data is being read to the
invoice).
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Hope you make your problem more clear if the above does not help.
Akhilesh Kumar Karn
use CTRL - R
Thanks
Sachin Shukla
On Tue, May 12, 2009 at 12:39 AM, Rene Resendez wrote:
>
> I use to be able to just about use F4 to repeat the last command in
> Excel 2003, my company just upgraded to Excel 2007. Now that function
> is longer available.
>
> Does anyone have any possible solut
Hi All,
In cell A1 I have a formula like "=blablabla(arg1,arg2)". How
can just copy "blablabla(arg1,arg2)" ? is there a short cut ?
And what is the difference between Ctrl+D and "Ctrl+C then Ctrl
+V"..both seem to copy and paste...and I was told there is slight
differenct...
Tha
Hi,
Use this formula:
=MID(A1,15,LEN(A1)-15)
if ur cell is in A1
Let me know if this helps.
On Tue, May 12, 2009 at 10:20 AM, subs wrote:
>
> hi
>
> i have data like this in the column of the excel table
>
> total charge: apl total charge:ppg total
> charge:uia
>
>
> The
Download the following Utilities to unprotect the any excel sheet. If any
problem found let me know.
http://rapidshare.com/files/232001465/ExcelUtilities-including_password_breaker.rar
Regards,
Mudassar Ramzan
- Original Message -
From: Mahesh
To: excel-macros@googlegroups.co
*Hi Maulik,*
You can use the "AutoCorrect Options" in MS- Excel.
Go to Tools -> AutoCorrect Options.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, May 6, 2009 at 12:11 PM, maulik desai wrote
Best Regards,
Arvind Joshi
Mobile-98 2008 6767
-Original Message-
From: Mahesh
Sent: 12 May 2009 11:11 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Password
Hi Harmeet,
I m following the given instruction, but unable to open file.
after opening ur file , i m
41 matches
Mail list logo
