Kindly Consider the Previous Mail
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/
hi! All,
What i need to be done is... I have three year data like
0708
0809 0910
No of order Values No of order
Values No of order Values
6 100 5
50 8
That did the trick, Paul. Thank you.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.c
Try this:
Dim rowcnt
Err.Clear
On Error Resume Next
rowcnt = Range("MyRange").Rows.Count
If (Err) Then
MsgBox "No More Rows!"
Exit Sub
Else
On Error GoTo 0
End If
Paul
From: 0 1
To: MS EXCEL AND VBA MACROS
Hi to all !
first of all I apologize for ma very very bad english ! (i'm a frenchy
guy)
in my excel 2007, i have make a userform which stay "on top"
of all windows (videos, powserpoint, pdf, etc ) --> that's
ok ! :-))
BUT, my problem (very big problem) is that , if I open
another excel shee
Dear All,
I had made a project in excel and some macro made but i had protected with
password and forget the password.
How can i recover my VBA password.
please give me some tips to accomplish my project.
sajid memon
--
--
I have a macro that deletes rows in a dynamic range if certain data
are missing. When this happens, the range obviously has no rows. I''m
trying to write a macro to determine when this has happened.
Basically:
IF the range has no rows THEN
MsgBox "Range has no rows"
ELSE
MsgBox "Range has r
Hi Experts
In my file "MAINSTORE.xls" I have a worksheet named "Old Items" have
to import in the file Backup.xls .With in my limitation I created a
macro by recording. The main problem is that it is not importing in a
format that I crated in the file MAINSTORE.XLS.Besides that it is
looks little b
This looks to be either "Off Topic",
or a hijacked thread (meaning that someone responded to a discussion topic with
a topic of their own, thus "taking over" the discussion)
However, since Hanamant was the original Topic author,
He's hijacking his own thread.. so I guess I'll answer...
Next time
Use custom number format set to 0"."00"."000
On Dec 20, 11:11 am, Rajiv Kumar wrote:
> Dear sir how can I write excel sheet dis format 1,85,000 in excel.
>
> It yes then please give me tips. Awating your positive replay…
>
> Raj
>
> Number Format.xls
> 19KViewDownload
--
-
Hi Paul
You clear my doubts well,Thank u very much.
Regards
Rajesh Kainikkara
On 12/20/10, Paul Schreiner wrote:
> Let's look at the command itself.
>
> The "normal" syntax of the SaveAs procedure is:
> ActiveWorkbook.SaveAs Filename:="C:\temp\NewFile.xls"
>
> Now, if you have a variable called
*
Thanks sir,,, but i wanna sum for the same .. formula which is sent u 1stly
its not working proprly so can u send it in 2nd sheet .. plz do the needful.
*
On Tue, Dec 21, 2010 at 3:40 PM, NOORAIN ANSARI wrote:
> Dear Rakesh,
>
> you can use Sumproduct for same output...
> Please see attach
Qualification: • BS in Computer Science, Computer/Software
Engineering, or equivalent experience
Key Skills:
• Business Objects Experience is KEY (2-4 years)
• 3+ years of Oracle SQL experience including proven SQL performance
tuning skills
• 1+ years experience with ETL systems eg. Informatica o
also just forgot to mention,replace the inverted comas with proper (just
type them)...
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 2:35 PM, Manoj kumar wrote:
> just remove "Option Explicit" and it is good to go...
>
>
> Regards,
> Manoj Kumar
>
>
> On Tue, Dec 21, 2010 at 11:23 AM, poojari sr
just remove "Option Explicit" and it is good to go...
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 11:23 AM, poojari sreevijay wrote:
> Hi team,
>
> Could any one please advise where i have gone wrong.
>
> The attached is the screenshot.
>
> --
> psreevi...@gmail.com
>
> --
>
>
Check if this works for you.
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 1:08 PM, Rohan Young wrote:
> Hi Experts,
>
> Please help me out the problem is if i check my status from master sheet
> for knowing how many projects are under process, when i select the statusfrom
> the drop down lis
*
Dear Sir,
Plz if any other formula... plz
*
On Tue, Dec 21, 2010 at 12:46 PM, NOORAIN ANSARI
wrote:
> Dear Rakesh,
>
> Please see attached sheet..
>
> Thanks,
> Noorain Ansari
>
> On Mon, Dec 20, 2010 at 11:02 PM, Rakesh Sharma
> wrote:
>
>> *
>> HI,
>>
>>
>> help required as mention
Dear poojari,
You have use Option Explicit and Not decleared Variable.
Right Code are here..
Option Explicit
Sub cubeRoot()
*Dim num As Integer*
num = InputBox("Enter a positive number")
MsgBox num ^ (1 / 3) & "Is the cube Rate."
End Sub
or without Varibale decleared code are here..
Sub cubeRo
18 matches
Mail list logo
