Hi Pawel,
Pls shere your workbook.
Regards
Prince
On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote:
Hi All,
I have quite serious problem with the list box (ActiveX). when I use it on
the sheet where is placed is fine, but when I run any macro that is going
to different
Pankaj i dont think it is possible without macro. You have to use macro to
do this task.
Regards
Prince
On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj wrote:
Dear Gurus,
I want to create a excel file with Date limit.
Like in a file there are some contents(Graphs, Dashboards Etc) with
hey there is there any way i can sum up data hourly/daily/monthly in a
given data
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
Dear experts,
I am struggling in one formula steps, please help me out. please find the
attachment for more information, please.
Actaully i want a formula which gives me like R column, please forget
about P, Q, R coloumn.
P, Q are only helping column for me, so that i can elaborate you all
Hey guyz, can anyone tell me the maximum # of dimenstions that can be
stored in a single array in VBA. I guess around 64 demensions but want to
confirm with you guyz.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Worked perfectly, thank you very much.
On 1 August 2013 14:10, De Premor d...@premor.net wrote:
Ups Sorry, my fault, i haven't change a variable to fit yours
Sub tes()
Dim oWSHShell As Object, OpenFile As String
Set oWSHShell = CreateObject(WScript.Shell)
OpenFile =
Some body can help me for creating the formula please
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 1:58 PM, Rajan sharma rajansharma9...@gmail.comwrote:
Dear experts,
I am struggling in one formula steps, please help me out. please find the
attachment for more information,
Ok can opt for Function if not then we will go with Macros
On Mon, Aug 26, 2013 at 12:39 PM, Prince prince141...@gmail.com wrote:
Pankaj i dont think it is possible without macro. You have to use macro to
do this task.
Regards
Prince
On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj
Dear Premor sir,
Exactly matching as per my requirement. Thanks a ton. even the formulas
are long it gives my solution.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 2:55 PM, De Premor d...@premor.net wrote:
Hi Rajan, try this long formula on Cell S2 or Just see at
Hello,
Can I get help from you to remove extra space / enter from column C in
the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
try this formula
=TRIM(SUBSTITUTE(C2,CHAR(10), ))
Pada 26/08/2013 17:33, Pravin Gunjal menulis:
Hello,
Can I get help from you to remove extra space / enter from column C
in the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi All,
unfortunately workbook is too big to share, but I've done some something
(below):
ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoFalse
ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoTrue
this is working, but still not perfect.
problem is that something (macros)
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space Enter to
=TRIM(SUBSTITUTE(C2,*CHAR(10)*, ))
SUBSTITUTE is to replace somestring, in our case we need to replace
ENTER Char(enter Char in ASCII Code is 10) to meet your requirement with
a single space to make it a single line, Then because there is soo many
space there, and you want to remove it, we
Thanks Premor sir,
Fantastic, Hats off to ur UDF.. thanks a ton.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 4:40 PM, De Premor d...@premor.net wrote:
Try this using UDF
Function SUMPB(Amount As Range, Unit As Range, RngCriteria As Range,
Criteria As String)
Dim i
Santy,
Absolutely phenomenal! Thank you for your brilliant, quick reply!
John
On Monday, August 26, 2013 8:56:14 AM UTC-4, Santy wrote:
Little lengthy formula but working fine
*Thanks Regards,*
*Santy*
On Mon, Aug 26, 2013 at 5:56 PM, John A. Smith
Hello Prabhu,
I dont comment on this forum much as I generally dont have the time. I saw
your topic and thought it worth a response because it it quite a tricky one
to get right (there are many failed attempts out there in the world). I
have done the different statistical forcasting methods
you can use the hyperlink method given by Jordan which he has used in us
map . link below
http://optionexplicitvba.blogspot.in/2012/08/interactive-map-in-excel-using-rollovers.html
http://optionexplicitvba.blogspot.in/2012/10/interactive-united-states-2012.html
On Sun, Aug 25, 2013 at 11:42 PM,
Hi Team,
Please refer the Sheet in which I need a formula which can calculate and
show the planned leaves in date format and should highlight in Red.
Thanks Regards,
Lucky
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
I have some data that is imported into Excel. It's a long string of text,
in one cell, that I have to split in 2 cells and get rid of unwanted data.
I've attached a file, I need to manipulate the data in ROW 3 to look like
the data in ROW 5. Normally i do this on the same row. I will copy
Try this macro
Sub Pierre()
Dim Rng As Range, Data As Range, iLeft As Integer
Set Data = Selection
For Each Rng In Data
iLeft = InStr(1, Rng, () + 1
If iLeft 1 Then
Rng.Offset(0, 1) = Mid(Rng, iLeft, InStr(1, Rng, )) - iLeft)
Rng.Offset(0, 0)
Do you want to show date rather than L sign?
On Mon, Aug 26, 2013 at 7:36 PM, Zibraan lucky60...@gmail.com wrote:
Hi Team,
Please refer the Sheet in which I need a formula which can calculate and
show the planned leaves in date format and should highlight in Red.
Thanks Regards,
Lucky
Thank you thankyou, it does exactly what I'm looking for.
The sad part is now I will be busier.
Thanks again.
Sub Pierre()
Dim Rng As Range, Data As Range, iLeft As Integer
Set Data = Selection
For Each Rng In Data
iLeft = InStr(1, Rng, () + 1
If iLeft 1 Then
Rng.Offset(0, 1) = Mid(Rng,
try the attached workbook see if it helps
On Mon, Aug 26, 2013 at 8:00 PM, Pierre Lanoue mingo.di...@gmail.comwrote:
I have some data that is imported into Excel. It's a long string of text,
in one cell, that I have to split in 2 cells and get rid of unwanted data.
I've attached a file, I
Thanks a lot
works like a charm
You are a star
On Sunday, August 25, 2013 4:03:48 PM UTC+4, De Premor wrote:
PFA
Pada 25/08/2013 18:22, prkhan56 menulis:
Hello De Premor,
It shows only blanks. No data at all.
Please check
Thanks for your time once again.
Rashid
On Sunday, August
Hi frog,
First of all many thanks for your time to explain with valuable points.
Really what you said is really useful for me.
Reason behind my post is, all the methods is working with some formula and
giving a result even if we use any tools available in markets. I just wants
to apply this
26 matches
Mail list logo
