group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/gr
Hi
Excel 2008 mac does not support VBA .
http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac
http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html
It might be reason that its not thr in right click
Regards
Ashish
On Tue, Aug 20, 2013 at 11:47 AM, ashish
if you are using mac excel then try Alt + Fn +F11
source:
http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html
On Tue, Aug 20, 2013 at 11:43 AM, ashish koul wrote:
> press alt +f11
>
>
> On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR wrote:
>
>> R
is group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes
his group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Ma
, 6
'
0 because source data is in same column
to know more about offset visit
http://www.techonthenet.com/excel/formulas/offset.php
if you require any further info please feel free to ask in the group
On Tue, Aug 20, 2013 at 10:30 AM, Chaya Cooper wrote:
> Ashish,
>
&g
because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegro
http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389
gt; 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "
d Help, Formula Problem, Code Problem, and Need Advice
>> > will
>> > not get quick attention or may not be answered.
>> >
>> > 2) Don't post a question in the thread of another member.
>> >
>> > 3) Don't post questions regarding breakin
oup.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more o
send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish K
Hi can u share some sample files and output workbook
On Fri, Aug 16, 2013 at 12:38 PM, Shrinivas Shevde
wrote:
> Dear Ashish
> I try this macro but there is a samll pr
> oblem when I open folder folder shows empty .actually there are 3 to 4
> excel worksheets in the folder
d an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regard
"MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.goog
o excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Lik
roup, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com
to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Faceboo
om.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.
L AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/ex
;p65356").End(xlUp).Row + 1)
Else
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 > 30").Range("a" & Sheets("T2 >
30").Range("p65356").End(xlUp).Row + 1)
et1").Range("Y" & i).Value <= 30 Then
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 < 30").Range("a" & Sheets("T2 <
30").Range("p65356").End(xlUp).Row +
message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegr
il to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Li
Check this page http://www.mcpher.com/Home/excelquirks/json
See if it helps
Regards
Ashish
On Tue, Aug 6, 2013 at 7:23 AM, De Premor wrote:
> **
> That would be great we have a sample file and what you need to do with it
> (what data you need to be exist on
t; NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this gro
oup.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
&g
http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
>
ooglegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <h
- used to count the range by checking multiple conditions.
> On Jul 29, 2013 8:28 PM, "Ashish Kumar" wrote:
>
>> Dear seniors,
>>
>> How can we use sum & sumifs , countif & countifs. and what is the
>> diffrence between. pls explain with formula and exa
Dear Rajasekhar,
THanks
On 29 July 2013 21:00, Rajasekhar Praharaju
wrote:
> Hi Ashish,
>
> Just go through this link... you have good examples...
>
> http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
>
> Thanks,
> Raj
>
>
> On Mon, Jul 29, 20
Dear seniors,
How can we use sum & sumifs , countif & countifs. and what is the diffrence
between. pls explain with formula and example. pls help me.
thanks
Ashish
--
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 Faceb
.Visible = False
End If
Next
Application.DisplayAlerts = True
End Sub
On Sun, Jul 28, 2013 at 10:27 AM, Sanjay Kumar Maurya <
mail2sanja...@gmail.com> wrote:
> Hi shish ji,
>
> Could you make a changes in attached file.
>
>
>
> On Sun, Jul 28, 2013 at 10:10 A
members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+u
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, accurate thread titles. Poor thread titl
Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
>
> Hi,
>
> It is working fine. In Cell A3 data is 958321.1 which is reversed
> as 1.123859.
>
&g
Dear VBA,
Thanks for your help and valuable support. this is woking fine.
Thanks,
Ashish
On 22 July 2013 11:44, vba wrote:
> Hi,
>
> It is working fine. In Cell A3 data is 958321.1 which is reversed
> as 1.123859.
>
> Pl check & confirm.
>
> T
Dear VbA,
thanks for your help. but this formula is not working properly.
Thanks,
Ashish
On 22 July 2013 10:27, vba wrote:
> PFA
>
> Thanks
>
>
> On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar
> wrote:
>
>> Dear Vabs,
>>
>> Thanks for you reply
lt;6,"",MID(B1,LEN(B1)-5,1))&
> IF(LEN(B1)<7,"",MID(B1,LEN(B1)-6,1))&
> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
> IF(LEN(
try this udf
Function revr(s As String)
revr = StrReverse(s)
End Function
On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar wrote:
> Dear Seniors,
>
> I have this type of data :
>
> 54321
> ASDF
> 8796564
> DFRESW
>
> But I want OUTPUT like below mentione
Dear Ashish sir,
thanks for your quick response, but this is not working & i want solve this
query only from excel formula not VbA. coz, i want to reverse string in
some columns not whole excel sheet. please suggest me how to resolve this
query from excel formula.
Thanks,
Ashish
On Su
hi
visit this link http://www.rondebruin.nl/win/s1/outlook/mail.htm
you will find multiple options for sending email automatically using macros
On Sat, Jul 20, 2013 at 6:54 PM, dynamitekicker wrote:
> Thanks Ashish! Word mail merge is a satisfactory solution, but ultimately
> I would
Dear Seniors,
I have this type of data :
54321
ASDF
8796564
DFRESW
But I want OUTPUT like below mentioned :
12345
FDSA
4656978
WSERFD
How to make ti reversal through formula. Please help ??
Thanks & Regards,
Ashish Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
gt; To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <
ny security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not
- Click on Protect Tab and check only on lock checkbox
- Click on Protect Sheet Tab and provide the Password and save it.
Thanks & Regards,
Ashish
--
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 f
Dear Vikas,
Can you please explain. what is this or how it works.
Thanks
Ashish
On Thursday, July 18, 2013 10:48:02 PM UTC+5:30, vikas wrote:
>
> Jvo gv Buchanan! R g chives PBS:;,?! Gyvfchvjbhjvijvonvpvpvppp0
> On Jul 18, 2013 9:42 PM, "Ashish Kumar" >
> wrote:
&
scribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://g
27;t post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links i
Dear Seniors,
I want to create a Cab Roster for my official purpose, but i have no idea
about that, does any one have an cab roster data of any company then please
share. please guys help me.
Thanks
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
his group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://gr
-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
F
to know which is the last range and paste it
> in sheet2. Is there anyway to do this.
>
> Please find attached updated excel & there will be many ranges in sheet1
> but I should know which is last range and paste same in sheet2.
>
>
> Regards,
>
> Chandra
>
> On W
e from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://gr
om.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Exc
ing emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
&
Dear Seniors,
Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
kanwaljit sir.
Thanks
Ashish
On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
> As told by Kuldeep Ji with a small change, which might be causing trouble
>
y...!! the formula is not working and I'hve use this formula with CSE.
Please suggest me, how i am resolve this.
Thanks
Ashish
On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>
> Hi Ashish,
>
> Formula is working fine. Please find the attachment.
>
> *Use
unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options
Dear Seniors,
Data Getting Error..please find the attached sheet for refrence.
Thanks
Ashish
On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Ashish,
>
> Please try it..
>
> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
> ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$
Dear Sir,
Data geeting Error. please find attached sheet for refrence.
Thanks
Ashish
On Tuesday, July 16, 2013 5:48:14 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear Noorain,
>
> Can you please elaborate the funtion!
> Thanks in advance.
>
> Sandeep Chhajer.
> Sen
Dear Seniors,
kindly find attached vlookup query, I want get output thru vlookup choose
function. please help me on this query and please explain me why we use
{1,2,3,4,} in formula.
Thanks in advance.
Thanks
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be
its asking to select folder, later file name, if
> i type file name, its actually pdf format but opening in excel format.
> cant we fix folder path in this program, so there is no need to select
> folder every time
>
>
> On Sun, Jul 14, 2013 at 11:57 AM, ashish koul wrote:
>
might be I am not explained clearly, example I have file name "350"
>
> in that folder i have file names from 1 to 5000, i will type this file
> name "350" in one cell, then i will run vba code, so it can open file with
> name "350". please help me
>
> r
easiest way is simply move this tab or copy the content of the tab to your
workbook and code too
In case u change the name of sheet .please change it in code too
Sheets("Plan").Select 6th line
Regards
Ashish
Regards
Ashish
On Sun, Jul 14, 2013 at 1:04 PM, shreya vyas wrote
t to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbama
s+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My
Hi Group
Please find amazing chart collection here
https://sites.google.com/site/e90e50charts/
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
Join Us
ps
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://group
-TC101877403.aspx
Regards
Ashish Koul
On Thu, Jul 11, 2013 at 5:07 PM, Kannan Excel wrote:
> hi friends,
>
> anybody have excel time tracking format?? i want to track my employee
> details in excel.. if i enter my employee id number means his it will come
> automatically...
copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL
ceived this message because you are subscribed to the Google
>> Groups
>> > "MS EXCEL AND VBA MACROS" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an
>> > email to excel-macros...@**googlegroups.com.
>> >
Dear Seniors,
Does any one have any type of CAB or Transport Roster Data. if yes, then
please share. I need it on urgent basis. Please Help..!!
Thanks,
Ashish
--
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
=TRIM(RIGHT(D3,LEN(D3)-FIND(")",D3)))
Regards
Ashish Koul
On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav wrote:
> Dear Amar,
>
> find the same with easy...by using mid function.
> Regards
> Prafull
>
>
> On Wed, Jul 10,
EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/
2) but it didn't work
>
> Thanks
>
>
> On Tue, Jul 9, 2013 at 9:24 AM, ashish koul wrote:
>
>> chk the attached file . see if it helps
>>
>>
>> On Tue, Jul 9, 2013 at 7:47 PM, wrote:
>>
>>> Here is a sample file with 2 example sheets
ROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
&
not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
t quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
visit these links
http://www.clearlyandsimply.com/clearly_and_simply/choropleth-maps/
http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html
http://www.clearlyandsimply.com/clearly_and_simply/2009/06/multicolored-choropleth-maps-with-excel.html
Regards
Ashish
m this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.g
Check ur google group settings
Sent on my BlackBerry® from Vodafone
-Original Message-
From: PrIyAnKa
Sender: excel-macros@googlegroups.com
Date: Fri, 5 Jul 2013 14:27:14
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Not getting daily emails
Dear Team
Kindly d
; ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, s
can u share the sample file with us
Regards
Ashish
On Thu, Jul 4, 2013 at 7:07 AM, Brian Yam wrote:
> Dear All,
>
> I am new to VBA programming
> I happen to need great and urgent help on a project that I am currently
> working on
> I would like to search through the work
delete the columns u don't want using vba
On Thu, Jul 4, 2013 at 1:19 PM, SG wrote:
> hi Ashish,
>
> thanks for the help.please help me in result as i want only name &
> accuracy to show.
>
> On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote:
>
>>
try the attachment . if ur data is in lakhs best is u use access
Regards
Ashish
On Wed, Jul 3, 2013 at 8:42 PM, SG wrote:
> hi Ashish,
>
> The data is in lakhs & advance filter would allow me to filter only one
> criteria.I have atleast 4 filters in this data.
> plz exp
gt; measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for
ou are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
&g
Hi Vabz,
I'hve follow your insturction and I'hve got my answer but when I'hve unhide
the sheet, the data will not showing. please help and advise for the same.
Thanks,
Ashish kumar
On Monday, July 1, 2013 2:06:10 PM UTC+5:30, Vabz wrote:
>
> Hi
>
> You can hide
Dear Seniors,
I have a data from Colum A to Column D in excel sheet, I want show only
this data in sheet & rest of sheet will be deleted and cursor will be
working only from Column A to Column E. like in JPEG image attached. kindly
find the attachment for refrence.
Thanks,
Ashish
--
its a simple x y scatter chart
to know more about charts visit
http://office.microsoft.com/en-in/excel-help/creating-xy-scatter-and-line-charts-HA001054840.aspx
Regards
Ashish
On Thu, Jun 27, 2013 at 6:20 AM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
>
nded recipient of this
> e-mail you may not copy, forward, disclose or otherwise use it or any part
> of it in any form whatsoever. If you are not the intended recipient please
> telephone or e-mail the sender and delete this message and any attachment
> from your system."
&
---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post
On 14 June 2013 11:13, Prabhu Pinky wrote:
> Hi asish..i can give inputs for you. Gimme some till will prepare a
> document and share to you..hope it may help you...
> On Jun 14, 2013 10:57 AM, "Ashish Kumar"
> wrote:
>
>> Dear Seniors,
>>
>> How to
Dear Seniors,
How to create a transport Cab roster. If, any one have an these type of
roster data or example, then please share. I want to create a transport cab
roster for my company. need help.
--
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)
Hi Kaushik,
Try this..!!!
Option Explicit
Private Sub CommandButton1_Click()
On Error Resume Next
Dim fso As FileSystemObject
Dim fld As Folder
Dim fil As File
Dim wkb As Workbook
Dim akb As Workbook
Dim i As Long
Dim fldpath As String
Application.FileDialog(msoFileDialogFolderPicker).Titl
Dear Seniors,
It is possible to change cursor colour in excel sheet from black to green.
If yes, then please help me and provide resolution. Thanks in advance.
Thanks
Ashish
--
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
res\desert.jpg")
With wk.Shapes(wk.Shapes.Count)
.Left = wk.Range("a1").Left
.Top = wk.Range("a1:c2").Top
.Width = wk.Range("a1:c2").Width
End With
Next
End Sub
On Fri, Jun 7, 2013 at 9:50 AM, Pravin Gunjal wrote:
> Dear Mr A
ooglegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook&l
701 - 800 of 2224 matches
Mail list logo