Congratulations Noorain,
All the best ...
You are the heart of this google group...
On Sun, Aug 5, 2012 at 10:30 AM, Aindril De wrote:
> Great Work Noorain!!
> Though I have been silent in this group for quite some time...
> However I keep following the posts.. almost everyday.. thx to great
>
Hi
Use this :
Sub SplitString()
Dim StrString As String
Dim VarArr
StrString = "| ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|"
StrString = Mid(StrString, 2, Len(StrString) - 2)
VarArr = Split(StrString, "|")
Range("A1").Resize(1, UBound(VarArr)).Value = Var
Great Work Noorain!!
Though I have been silent in this group for quite some time...
However I keep following the posts.. almost everyday.. thx to great members
like you, from whom I learn everyday...!
Cheers and Keep up the good work,
Regards,
Andy
On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wr
Heartly thanks to all of you
Sent from BlackBerry® on Airtel
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 23:10:25
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member
Dear Excel Experts,
I am working with a string as follows:
" | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|"
There are a total of 8 pipes | .
My issue is that I am trying to Split this based on the pipes, and output
the words in between into cells.
I have been trying to solve this for a lon
very well explained Rajan
On Wednesday, August 1, 2012 10:46:27 AM UTC+5:30, vijayajith VA wrote:
>
> Hi Gurus,
>
> Please could you explain what is the use of Public & public const in vba
> macros.
>
> could you provide me one simple example...
>
> Thanks
>
>
>
>
>
>
--
FORUM RULES (986+
Congtates Noorain bhai.
On Sat, Aug 4, 2012 at 8:53 PM, wrote:
> **
> Thanks Noorain for your effort. Also, thanks to all the people in the
> group for your voluntary help.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * "Indrajit $nai"
> *Sender: * excel-
check the attachment see if it helps also visit for clocks
http://www.andypope.info/fun/clocks.htm
http://spreadsheetpage.com/index.php/file/analog_clock_chart/
http://excelunusual.com/archive/2010/12/making-a-clock-in-excel/
http://cpap.com.br/orlando/ExcelClockMore.asp?IdC=OMKtPlcG
http://chando
Dear Experts,
I need a macro which started counting in any cell in "hh:mm:ss" format.
Also, another macro needs to stop that counting (stop time may be vary)
Thanks in advance.
Regards,
Dhananjay
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
Sorry. I would like to thanks to Ayush. Ashish Kaul as well.
On 8/4/12, Dhananjay Pinjan wrote:
> Hi Experts,
>
> I am Dhananjay Pinjan from Pune, Age- 28, working at TATA Motors Ltd.
> I always like to work with Excel Features. I become Excel addict. I
> also encourage people to use the Excel’
Hi Experts,
I am Dhananjay Pinjan from Pune, Age- 28, working at TATA Motors Ltd.
I always like to work with Excel Features. I become Excel addict. I
also encourage people to use the Excel’s maximum features which save
our time a lot.
And Ashish, you are fantastic. You are driving this forum so
Hi Rajan,
I have replaced the error line and i got the exact employee's number of
working days, but the 4 hrs of macro timings are not multiplied to those
users. Please check and do the needful brother.
Regards
Lokesh.M
On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma wrote:
> *Replace error line wi
Hi, this is Ashish from Delhi works as derivatives trader, passionate about
travelling and cooking, finding ways to build my trading model using
arbitrage strategies on excel.
regards,
Ashish
On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
Thanks Noorain for your effort. Also, thanks to all the people in the group for
your voluntary help.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Indrajit $nai"
Sender: excel-macros@googlegroups.com
Date: Sat, 4 Aug 2012 20:48:25
To:
Reply-To: excel-macros@googlegrou
Congrats Noorain. :)
On Sat, Aug 4, 2012 at 5:20 PM, jmothilal wrote:
> Thanks with Congrats Noorain.
>
> Mothilal.J
>
> On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote:
>
>> Good work!
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>
Thank you so much Rajan,
On Sat, Aug 4, 2012 at 7:40 PM, Rajan_Verma wrote:
> *Hi Vijay,*
>
> * *
>
> *Let’s clear the things about Public and Const.*
>
> * *
>
> *Public/Global]** : ** : Public is the scope of variable ,
> which tell vba where the variable would be available fo
Hi Vijay,
Let's clear the things about Public and Const.
Public/Global] : : Public is the scope of variable , which tell
vba where the variable would be available for access.
Const :Const denote the constant type
variable .. it means the value ass
congratulation there
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't pos
Thanks with Congrats Noorain.
Mothilal.J
On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote:
> Good work!
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ayush Jain
> *Sent:* Friday, August 03, 2012 12:40 PM
> *To:* excel-macros
> *Subject
Dear All,
How can i use Tally ODBC for multiple queries.
Suppose i want get data of Tally Day Book.
thanking u
Regards
Sudhir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula P
please explain some more..
On Fri, Aug 3, 2012 at 11:39 AM, Kenil Gala wrote:
> hi folks,
> i am having a query in getting external data,
> pls help me for the same.
> i have written my query in the excel sheet.
>
>
> Thanks in adv,
>
> Regards,
>
> --
> FORUM RULES (986+ members already BANNED
use odbc connection for export and import data from access to excel
On Fri, Aug 3, 2012 at 6:08 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data
Hi Ashish,
Please see attachment.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Sat, Aug 4, 2012 at 4:19 PM, Rajan_Verma wrote:
> *=SUMPRODUCT
Congratulation Noorain Bhai
On Sat, Aug 4, 2012 at 12:53 AM, wrote:
> **
> Congrats Boss. Keep up the momentum
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * Ayush Jain
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 3 Aug
=SUMPRODUCT((A7:A23>=E1)*(A7:A23<=F1)*(F7:F23))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Bhalara
Sent: 04 August 2012 4:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Su
Replace error line with this :
.Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop, -1).Value
+ (4 * objDic.Count)), "hh:mm:ss")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lok
Dear experts,
I need output of sum between two date by using of Sumproduct as below
formula but the error is occur in fuction, please see attache sheet.
=SUMPRODUCT(A7:A23>E1)*(A7:A23
Sumproduct Function.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Hi Experts,
Any buddy please resolve this query because of i need as soon as possible.
Regards
Lokesh.M
On Sat, Aug 4, 2012 at 6:48 AM, Lokesh Loki wrote:
> Hi All,
>
> Still i am not getting reply from the experts. Please do the needful.
>
> Regards
> Lokesh.M
>
>
> On Thu, Aug 2, 2012 at 5:5
Congrats Brother. Keep up the momentum.
Regards
Lokesh.M
On Sat, Aug 4, 2012 at 11:33 AM, vijayajith VA wrote:
> Congratulations Noorain bayya!!
>
> On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote:
>
>> Dear members,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for
Hi Kantilal,
Thank you so much for resolving the query. Have a great day.
Regards
Lokesh.M
On Sat, Aug 4, 2012 at 8:11 AM, Kantilal Badale
wrote:
> Dear Lokesh,
>
> Please see attached sheet
>
> Regards
>
> CA Kantilal Badale
> 9822250393
>
> On Sat, Aug 4, 2012 at 6:45 AM, Lokesh Loki wrote:
>
Hi ,,
Use Ctrl Shift enter for Priti_Verma s formula...
Thanks
On Sat, Aug 4, 2012 at 1:17 PM, amar takale wrote:
> Pls help me all experts.I attached file.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like P
Try this in C15:I15 as array
=TRANSPOSE(OFFSET(INDEX($C$5:$N$5,1,MATCH(C14,$C$5:$N$5,0)),1,0,6,1))
Priti
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 04 August 2012 1:18
To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
Hi,
Please provide required details regarding below online SAP training.
Regards,
Vikram
On 8/3/12, David wrote:
>
>
> SAP Business Objects 4.0 Online Training, Job Oriented Online Course and
> Placement in USA, NewyorkSys is leading IT Online Training Company in USA.
>
> Newyorksys growing an
33 matches
Mail list logo