Hi Chaya,
I Hope This may Help you.
Sub Test()
Dim varData As Variant
Dim intCtr As Integer
Dim intChr As Integer
Dim intLen As Integer
Dim rngData As Range
Dim strNum As String
Dim strString As String
Dim
Dear All Experts
Thank you very much all to proper guidance about Countif formula
Regards
Amar
On Sat, Apr 6, 2013 at 2:20 PM, prafull jadhav wrote:
>
> Dear Amar,
>
> These both formula is same ..when you use the countif function then use
> =COUNTIF($F$3:$F$74,B3)
> and if there is multiple c
Prafull,
The problem with reading books on VBA for a complete stranger to coding is
it appears as Greek, and however easy language they have, it becomes of
less interest afterwards due to lack of understanding.
A neat way to start would be recording a macro. Just do something in excel,
like color
Dear Anil,
it is perfect and I appreciated.
I am also learning Excel Macro but I am not able to understand from where I
have to start .
what is beginning point to understand .how to create short macro code in
excel .
Can you guide me for the same .
Thanks in Advance .
Regards,
Prafull Jadhav.
Dear Anil sir,
Thank you very much.
Sir, i want including gaps too. Say example :
.DEEPA BHARATH 9874563147 98745895421 98451236547
i want numbers seperately not combine together as
9874563147987460
col1 : 9874563147
col2 : 98745895421
col3 : 98451236547
once again thanks.
Dear Chaya,
Pl see the attached sheet it will help u .
Warm Regards,
Gawli Anil.
On Mon, Apr 8, 2013 at 10:20 AM, Chaya wrote:
> Dear Experts and folk,
>
> I have been trying to extract numbers and words seperately from
> the strings. Manually i did, but taking huge time and even more
Dear Experts and folk,
I have been trying to extract numbers and words seperately from the
strings. Manually i did, but taking huge time and even more to go. Is there
any other way to extract as per my requirement.
i have attached my sample sheet and my requirement in the excel
fil
No Diffrence
Regards
Prince
On Saturday, April 6, 2013 1:46:33 PM UTC+5:30, amar takale wrote:
>
> Dear Experts
>
> what is Different between two formulas bcos from this formula I got same
> answer.So what is logic of "="&
>
> =COUNTIF($F$3:$F$74,"="&B3)
>
> =COUNTIF($F$3:$F$74,B3)
>
> Regards
If your static workbook is opened from the code, then you probably are
keeping the 'dynamic' workbook open first. So it would be best to replace
your underlined code above with *Set wb = ActiveWorkbook*
Regards,
Sam Mathai Chacko
On Sun, Apr 7, 2013 at 7:28 AM, LJGIT wrote:
>
>
> I need to swi
