Thanks Price,
but you have any idea of the best forum like we have this for VBA?
there are any forums but we wont know unless we join it so can you recommend
any like this one?
>
> From: Prince
>To: excel-macros@googlegroups.com
>Cc: han
.Net - Dot Net
>
>
>Put
>
>
>Learn . net
>
>
>
>
>into Google and you will get about 74 million possibles
>
>
>RegardsDavid Grugeon
>
>
>On 30 January 2013 17:52, hanumant shinde wrote:
>
>Hi friends,
>>
>>i dont know ANYTHIN
Hi friends,
i dont know ANYTHING about .net. and now want to learn it does anybody know how
shud i start with it.
Any site or ebook for beginners.
i am sorry this is off the track.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use conci
Hello Friends,
set xyz = new Excel.Application
I am getting error no. 48 (Error in loading DLL) for above code on one of the
machines whereas on other machines code is running fine.
can you guys please help me how can i resolve this issue.
--
Join official Facebook page of this forum @
http
el-macros@googlegroups.com
>Cc: hanumant shinde
>Sent: Sunday, 23 December 2012 11:42 AM
>Subject: $$Excel-Macros$$ Re: Reason for delay in Filter
>
>
>Hi Prashant,
>
>
>Please share your workbook so that we diagnose the problem and can provide
>whatever best we can do.
>
&
Hi Friends,
Can somebody please tel me what are the reasons for delay in Autofilter code.
We have a macro file where in one of the function we have used
Selection.AutoFilter Field:=1, Criteria1:="a"
This code is executed thousand times and it takes almost 1.75 seconds to
execute above line onc
hearty congratulations Paul. i would like to know your blog link if you post
the blogs.
your knowledge is tremendous.
>
> From: Ayush Jain
>To: excel-macros
>Sent: Monday, 3 December 2012 11:58 PM
>Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Membe
l-macros@googlegroups.com
>Sent: Fri, November 30, 2012 2:29:06 AM
>Subject: Re: $$Excel-Macros$$ Scraping data from image
>
>
>thanx fr ur reply i will google it. but is it posible fr u too xplain it in
>more this will help me.
>
>Sent from Samsung Mobile
>
>
>xlst
Hi,
Is it possible to capture (scrape) data from .doc file but the data on this
.doc file is pasted as image.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Hi friends.
there is huge macro file which throws an error as "Cant exit design Mode" for
few users at few occasions.
we don't know when and why this error comes but it was told us that this error
comes when we open Office 2003 file which has ActiveX control buttons in office
2007 version.
can
n VBA & VSTO within a couple of
years..
>
>Regards
>Deepak
>
>
>On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde
>wrote:
>
>Hi,
>>
>>Can somebody please tell me what is the difference between VSTO and VBA.
>>
>>I have heard VBA has left
>
>
>http://netindonesia.net/blogs/andriyadi/archive/2008/08/20/vba-vs-vsto.aspx
>
>
>Best Regards,
>Venkat
>Chennai
>My Linked in profile
>
>
>
>On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde
>wrote:
>
>Hi,
>>
>>Can somebody plea
;
>Application.Calculation = xlManual
>sheets.select
>for i=1 to
sheets.count
>activesheet.calculate
>next i
>
>
>
>Don
Guillett
>SalesAid Software
>dguille...@gmail.com
>From: hanumant shinde
>Sent: Friday, February 10, 2012 11:08 AM
>To: Excel Group
Hi,
Can somebody please tell me what is the difference between VSTO and VBA.
I have heard VBA has left short life after Office 2010 is released.
Can somebody please explain how much is the truth or what are the chances and
etc, etc
--
FORUM RULES (986+ members already BANNED for viola
Hi,
Can you please give any code or anything which will replace
Application.CalculateFull.
when i use above code this calculates all the Open workbooks whereas i want to
calculate only the Activeworkbook.
i have tried below code but its not reliable as it does not calculate EVERYTIME.
Publi
Hey Amit,
>
>look for SUMPRODUCT formula information and you will get your answer.
>
>From: Amit Desai (MERU)
>Sent: Saturday, January 28, 2012 2:43 AM
>To: excel-macros@googlegroups.com
>Subject: RE: $$Excel-Macros$$ Excel - Array Help
> Thanks
Noorain,
>
>I
have just seen your email...
>
1 1:19 AM
>Subject: RE: $$Excel-Macros$$ last cell by Formula
>
>
>Read this :
>
>http://www.techonthenet.com/excel/questions/last_value.php
>
>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
>Behalf Of hanumant shinde
>Sent: 26 December
Hi,
it was interview que.
how can you find last cell jus by formula.
also, can somebody tell help clear my OOPs concept.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
t;Don Guillett
>SalesAid Software
>dguille...@gmail.com
>
>From: hanumant shinde
>Sent: Wednesday, December 21, 2011 3:08 PM
>To: Excel Group
>Subject: $$Excel-Macros$$ Return More than 1 value from Function
>Hi,
>
>How can we return more than 1 value from 1 function.
& My.Name & " and my address is " & My.Address & ".",
>vbInformation
>End Sub
>
>Asa
>
>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
>Behalf Of hanumant shinde
>Sent: Wednesday, December 21, 2011 1:08 PM
>To: Exce
Hi,
How can we return more than 1 value from 1 function.
1. using array
2. using By Ref for the values.
3. Create a class with the properties you require to return and then return the
object of that class from the function.
i understand 1st two methods. can somebody explain the 3rd and how to a
Hi,
Code is exactly the same except 1 change.
excelfile = Dir() this is used to change the name of the file.
Sub test2()
Dim path As Variant
Dim excelfile As Variant
path = "C:\Documents and Settings\rjosh14\Desktop\inn\Check\"
excelfile = Dir(path & ("*.xls"))
Do While excelfile <
Hi,
How to find if the command button present on Excel 2003 worksheet is ActiveX or
form control.
Also, how to add form control command button on excel 2003 sheet.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
dont know if you got my previous mail or not but i myself didnt get it so
resending it.
>
> From: hanumant shinde
>To: "excel-macros@googlegroups.com"
>Sent: Sunday, 18 December 2011 2:06 AM
>Subject: Re: $$Excel-Macros$$ Mid
fantastic explanation. thanks :)
>
> From: Asa Rossoff
>To: excel-macros@googlegroups.com
>Sent: Sunday, 18 December 2011 4:51 AM
>Subject: RE: $$Excel-Macros$$ urgent,can anyone teach me "Private Const
>LLKHF_ALTDOWN = &H20 "meaning
>
>
>Hi Garcia,
>
>The k
you can use
Alt+D+F+S :- this will clear filter value but keep the filter
or
Alt+D+F+F :this will clear filter values and apply/remove filter.
>
> From: vijayajith VA
>To: excel-macros@googlegroups.com
>Sent: Sunday, 18 December 2011 12:17 PM
>Subject: Re:
Hello Amir,
you can use below formula as well.
=LEFT(MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",MID(A2,FIND("
",A2)+1,FIND(" ",A2,FIND(" ",A2)+1
but i think below formula is much shorter than this 1. :)
>
> From: Aamir Shahzad
>To: exc
Thanks Rohan, :)
Noorain has given 1 very easy code
Dim str
str = Split(rng, word)
Count_character = UBound(str)
>
> From: Rohan
>To: MS EXCEL AND VBA MACROS
>Sent: Wednesday, 14 December 2011 1:06 AM
>Subject: Re: $$Excel-Macros$$ No. of Occurrence of char i
>str = Split(rng, "e")
>Count_character = UBound(str)
>End Function
>
>
>--
>
>Thanks & regards,
>Noorain Ansari
>http://excelmacroworld.blogspot.com/
>http://noorain-ansari.blogspot.com/
>On Sat, Dec 10, 2011 at 1:40 AM, hanumant shinde
>wrote
;
>if "excel" is in A2 cell then LEN(A2)-LEN(SUBSTITUTE(A2,"e",""))
>
>Regards
>Muni
>
>
>On Fri, Dec 9, 2011 at 3:10 PM, hanumant shinde wrote:
>
>Hi All,
>>
>>
>>it was an interview que.
>>
>>
>>how will
got the ans with lots of other things just check this out.
http://support.microsoft.com/kb/187667
>
> From: hanumant shinde
>To: Excel Group
>Sent: Saturday, 10 December 2011 1:40 AM
>Subject: $$Excel-Macros$$ No. of Occurrence of char in stri
Hi All,
it was an interview que.
how will you find number of occurrence of any character from string.
he said you can do it using 1 excel formula or you can use VBA.
can somebody tell me the answer in both Excel as well as in VBA.
eg. if string is "excel" then there are 2 "e"s in this string.
nd it to the group
>
>
>On Thu, Dec 1, 2011 at 11:10 PM, hanumant shinde
>wrote:
>
>Hi Experts,
>>
>>Can somebody please suggest something for the below problem.
>>i am stuck due to this issue. i tried google but in vein.
>>please help me out.
>>
&g
Hi Experts,
Can somebody please suggest something for the below problem.
i am stuck due to this issue. i tried google but in vein.
please help me out.
From: hanumant shinde
>To: Excel Group
>Sent: Tuesday, 29 November 2011 8:02 PM
>Subject: $$Excel-Macros$$ Excel to Word
>
&
Hi,
i want to copy paste data from Excel to specific location in microsoft word
using Excel macro.
i am able to copy paste it at the beginning of word document but not on
specific location.
below is my requirement.
1. i need to find specific word in microsoft word doc ---> Done
2. just 1 place
one workbook to another workbook, you just need to
>ensure both the workbooks are open in the same instance of the application.
>
>Regards,
>Sam Mathai Chacko
>
>
>On Mon, Nov 21, 2011 at 10:46 AM, hanumant shinde
>wrote:
>
>Hi,
>>
>>
>>Thank you al
t;
>Best Regards,
>Venkat
>Chennai
>My Linked in profile
>
>On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde
>wrote:
>
>Hi Friends,
>>
>>i have attached screenshot which has 2 windows for paste special
>>functionality.
>>i wanted to paste o
t;
>End Sub
>
>Regards,
>
>Sam Mathai Chacko
>
>
>On Thu, Nov 3, 2011 at 10:58 PM, hanumant shinde
>wrote:
>
>Hi Friends,
>>
>>i need to find out scope of the name range i.e. if the defined name is has a
>>scope of worksheet or workbook.
>>
Hi Friends,
i need to find out scope of the name range i.e. if the defined name is has a
scope of worksheet or workbook.
below is my code
sub test
dim namerange as name
for each nameange in thisworkbook.names
a = namerange.name
'here i want to find out th scope of the name range.
lets say
n excel.
>
>
>Aamir Shahzad
>
>
>
>On Fri, Oct 21, 2011 at 1:30 AM, hanumant shinde
>wrote:
>
>yes very much possible with hardly 5 lines of code (if u want it for time
>being).
>>
>>send us the file or use the below code in the file if u can.
i think it will be better if you google all this information given by Dilip as
explaining everythign in detail is not possible so if u google all this you
will have better idea.
1. While, do while and do until are same hardly any difference.
2. for and for each is also same but for is used when
yes very much possible with hardly 5 lines of code (if u want it for time
being).
send us the file or use the below code in the file if u can.
Sub Macro1()
ChDir "Your Path"
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
Activ
ites that could be recommended are
>
>http://www.ozgrid.com/News/pivot-tables.htm
>http://msdn.microsoft.com/en-us/library/aa164537%28v=office.10%29.aspx
>http://www.zerrtech.com/content/pivot-table-creation-using-excel-vba
>
>Regards,
>
>Sam Mathai Chack (GL)
>
>
>On Sa
http://excelmacroworld.blogspot.com/
>http://noorain-ansari.blogspot.com/
>On Sat, Oct 15, 2011 at 12:56 AM, hanumant shinde
>wrote:
>
>Hi frends,
>>
>>
>>need to learn Pivot programming do you have any good stuff or site which you
>>can refer to me?
>>
Hi frends,
need to learn Pivot programming do you have any good stuff or site which you
can refer to me?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
Hi Paul,
this is superb i never knew this thing. never even thought this might be
happening.
thanks for sharing it.
>
>From: Paul Schreiner
>To: excel-macros@googlegroups.com
>Sent: Friday, 7 October 2011 4:05 PM
>Subject: Re: $$Excel-Macros$$ A macro pauses e
Hi,
Any idea about all these reports?
Daily CVA Risk Reports
Consolidated GRC Risk Report
BCM Risk Reports
Hedge Report & Monthly Risk Reconciliation
o Generate PNL reports:
GRC CVA Risk-based P&L Predicts
Public Finance CVA Report
DPCs & Monolines CVA Report
o Explain the da
Thanks Noorain
>
>From: NOORAIN ANSARI
>To: excel-macros@googlegroups.com
>Sent: Wed, 14 September, 2011 8:36:57 AM
>Subject: Re: $$Excel-Macros$$ INTERVIEW Quetions
>
>
>Dear Hanumant,
>
>Please find attached EXCEL VBA Interview questions.
>
>
>On Wed, S
Thanks Kris
>
>From: Kris
>To: excel-macros@googlegroups.com
>Sent: Wed, 14 September, 2011 10:58:10 PM
>Subject: Re: $$Excel-Macros$$ UNIQUE values in Array
>
>Hi,
>
>
>I'm not sure you found a solution for this. This
>link
>http://www.excelfox.com/forum/showthread.php?31-Data-Validation-Depe
Hi,
Can somebody give me Interview questions for experienced VBA developer.
i have some experience in EXCEL VBA and i will be looking for change so it
would
be really great if you could send interview questions if possible with answers.
Thanks.
--
Hi,
I have problem in getting data in Recordset object variable. There are few
columns which i am capturing from database into Recordset object.
But there is 1 column named "Fix History" string data type and has length more
then lets say 1 char is creating poblem. this fix history is not cap
AWESOME and very easy . i was thinking in wrong direction. thanks Rajan
>
>From: Rajan_Verma
>To: excel-macros@googlegroups.com
>Sent: Fri, 19 August, 2011 5:51:44 PM
>Subject: RE: $$Excel-Macros$$ Countdown
>
>
>
>Try this
>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.c
nobody has any idea abt it?
- Original Message
> From: hanumant shinde
> To: Excel Group
> Sent: Fri, 12 August, 2011 3:30:08 AM
> Subject: $$Excel-Macros$$ Making Excel Project Unviewable
>
> i dont know if this message was delivered or not
i dont know if this message was delivered or not. so resending it
- Original Message
> From: hanumant shinde
> To: Excel Group
> Sent: Tue, 9 August, 2011 3:30:36 AM
> Subject: Making Excel Project Unviewable
>
> Hi how to make project unviewable i.e. when we do
guillett1
> To: excel-macros@googlegroups.com
> Sent: Thu, 11 August, 2011 10:44:07 PM
> Subject: Re: $$Excel-Macros$$ UNIQUE values in Array
>
> If I recall properly, your function skipped 1. How do you want it
> presented???
>
> -Original Message-
> From: hanuman
eDim List(rng.Cells.Count) As String
> For Each cell In rng
> flag = 0
>
> For t = LBound(List) To UBound(List)
>
> If cell.Value = List(t) Then
>
>
> flag = 1
>
> Exit For
>
Hi how to make project unviewable i.e. when we do Alt+F11 and try to expand the
code it shows below pop up.
i have a file which if i try to open shows pop up saying "project is unviewable"
i tried to send the file but i cannot attach it. i think this is 1 more
functionality.
that excel file ge
End If
> Next
> UniqueList = List(Pos)
> End Function
>
>
>
> -Original Message-----
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of hanumant shinde
> Sent: Saturday, August 06, 2011 2:20 AM
> To:
coding macro
> See this
> http://www.youtube.com/watch?v=B_sd5lJX65M
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of hanumant shinde
> Sent: Friday, August 05, 2011 10:50 PM
> To: Excel Group
Hi Noorain,
how did you hide the sheet2. i could unhide it but programatically not
manually. its not even xlsheetveryhidden
>
>From: NOORAIN ANSARI
>To: excel-macros@googlegroups.com
>Sent: Fri, 5 August, 2011 11:51:51 AM
>Subject: Re: $$Excel-Macros$$ Excel test
>
>
>Dear XLS,
>
>Please see
Hi friends,
i have some values in column A. i want to take only UNIQUE values in some
array.
how can i do so?
i have developed below function and is working exactly i want it to be but i
think there should be more efficient way of doing so like there may be array
function for storing only UN
Thanks a lot Noorain
This is FANTASTIC, SUPERB truly awesome.
>
>From: NOORAIN ANSARI
>To: excel-macros@googlegroups.com
>Sent: Mon, 25 July, 2011 11:14:20 PM
>Subject: Re: $$Excel-Macros$$ use of indirect function
>
>
>Dear Neil,
>
>Please see attached sheet with Indirect function example
>
>
awesomethanksVenkat
From: Venkat CV
To: excel-macros@googlegroups.com
Sent: Tue, 26 July, 2011 12:16:54 PM
Subject: Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE)
Hi Harsh,
Try the Below link for All lessons and continuation of Below..
http://www.excel-vba.com/excel-v
ur name range (PDATA) shud start frm col B and not from col A.i.e. from col B
to
col F or may b more if u like. so the new formula will b
=VLOOKUP(K13,PDATA,5,FALSE)
formula without name range.
=VLOOKUP(I18,$B$2:$F$3,5,FALSE)
this will solve the problem
>
>From: SAJID MEMON
>To: Excel Group
namerange before increasing it. so wen i delete
it there is no nameange and wen i was adding the same namerange its scope was
workbook and not the worksheet.
i hope this will help.
- Original Message
> From: hanumant shinde
> To: excel-macros@googlegroups.com
> Sent: Mon
ible, share the test file.
>
> Best Regards,
> DILIPandey
>
> On 7/9/11, hanumant shindewrote:
> > Hi friends,
> >
> > i have a file in which there are 2 sheets. sheet A and B. i am giving name
> > ranges in sheet B as below.
> >
> >
>
nge Issue with Macro
>
> Hi Hanumant
>
> It is interesting..
> I am assuming that code first changes the range for the name and then
> the same is getting used. Try changing the order or refresh
> (Calculate) the sheet.
> If possible, share the test file.
>
> Best Rega
Hi friends,
i have a file in which there are 2 sheets. sheet A and B. i am giving name
ranges in sheet B as below.
A1:A20 - "Range1"
B1:B20 - "Range2"
C1:C20 - "Range3"
D1:D20 - "Range4"
these name ranges are used in Sheer A.for data validation
programatically i am increasing these ranges
>Regards:
>CMA Ankur Pandey
>(Someone Different)
>
>I'm not the best but i'm not like the rest~~
>
>
>On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde
wrote:
>Hi friends,
>
>is there any way where we can copy data from closed workbook "A" and paste it
s$$ copy data without opening file
>>
>>hi hanumant
>>
>>you may find this to be useful
>>
>>http://spreadsheetpage.com/index.php...a_closed_file/
>>
>>Have A Nice Time & Enjoy Life
>>
>>Regards:
>>CMA Ankur Pandey
>>(Someone D
nt
>>
>>you may find this to be useful
>>
>>http://spreadsheetpage.com/index.php...a_closed_file/
>>Have A Nice Time & Enjoy Life
>>
>>Regards:
>>CMA Ankur Pandey
>>(Someone Different)
>>
>>I'm not the best but i'm not like
Hi friends,
is there any way where we can copy data from closed workbook "A" and paste it
into workbook "B" which is open?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and link
Hi Friends,
I really need urgent help. i want to deliver smthing by tomorrow and i stuck
here.
Selection.FormulaArray =
"=RC[-4]:R[46]C[-4]&RC[-3]:R[46]C[-3]&RC[-2]:R[46]C[-2]"
I have this formula and instead of 46th row i want to use Variable "Z". i tried
below things but its not working
Hi friends,
this is really really urgent and very very very IMP for me so quick help would
be really really appreciated.
Name No
a 1
s 2
d 3
f 4
g 5
h 6
j 7
data is like above i.e. first Name and then No. i want to Vlookup for No.
values
and get Name but without moving any col or modi
n workbooks, without exception ...
>The macro must be enclosed in the book to which you want to work only
>work if it is enabled
>
>Chilexcel
>
>
>2011/5/29 hanumant shinde
>
>can u pls give some light on this coding. i tried to debug but it jus have
>s
can u pls give some light on this coding. i tried to debug but it jus have
sendkey F9.
so if i manually press F9 key in other workbook nothing happens there. can u
explain the logic of this macro.
>
>From: ChilExcel
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 8:42:50 PM
>Subjec
Hi,
what is the significance of -- just before TEXT in the below formula. this
formula works same even without --.
>
>From: Sixthsense
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 3:55:33 PM
>Subject: Re: $$Excel-Macros$$ How to change Date format in to number
>
>Hi Prabhu,
>
Hi Prabhu,
just convert those dates into below format using below formula.
lets say in col A17 thr is date thn in col B17 type this formula.
=TEXT(A17,"mmdd")
A B
5/29/2011 20110529
>
>From: Prabhu
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 9:35:23 AM
>Subject: $$E
Just replace the year from 2011 to 2010. by using replace all
- Original Message
> From: Rich Prince
> To: MS EXCEL AND VBA MACROS
> Sent: Thu, 26 May, 2011 6:49:10 PM
> Subject: $$Excel-Macros$$ Dates in Excel
>
> I have a column of various dates that have the incorrect year, for
>
hen you reply to a post the moderators must approve it before it will
> appear. The delay in your reply and when it shows varies.
>
> On May 25, 3:16 pm, hanumant shinde wrote:
> > just checking if i can send a mail or not. i had sent a reply to 1 post but
i
> > ca
just checking if i can send a mail or not. i had sent a reply to 1 post but i
cant see my reply. i dot know whats wrong.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
jus delete Range("B5029").Select
so your macro will b like this.
you have recorded this macro. record it again but just delete that Range thing
' NOWENTRY Macro
' Enters current time and date
'
' Keyboard Shortcut: Ctrl+n
'
ActiveCell.FormulaR1C1 = "=NOW()"
Selection.Copy
Select
> From: hanumant shinde
> To: Excel Group
> Sent: Sat, 7 May, 2011 1:37:54 AM
> Subject: $$Excel-Macros$$ Macro to monitor another Macro
>
> Hi Guys,
>
> lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has macro
> which runs automatically and sometim
Hi Guys,
lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has macro
which runs automatically and sometimes it throws OLE error for which we need to
MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and
whenever that OLE error occurs it should click OK auto
Hi Golden Lance,
its amazing. i didnt know we can work like this also. thanks a lot for your
input.
- Original Message
> From: GoldenLance
> To: MS EXCEL AND VBA MACROS
> Sent: Sat, 30 April, 2011 9:14:51 AM
> Subject: Re: $$Excel-Macros$$ Convert Excel Ranges to PDF
>
> Hanumant,
Jus want to see if i can send mail to this grp or not.
--
--
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 @ htt
Hi Paul,
Explanation is awesome. i have been reading your replies most of the time as
you
explain whole thing perfectly and in a good way. i dont know n dont understand
how do you know this much in detail theory.
You rock man. please keep up the good work.
Hi Guys,
is it a way where i can compare 2 sheets. lets say sheet1 and sheet2.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Hi Friends,
how can we convert the numeric value to its text e.g. if i type 1 its text
value
should be One if i type 132 its text value should be One hundred thirty two.and
so on.
--
--
Some important links for ex
Bhushan
If you are expert in anythign company is wating for you. Rob Bunce one of the
gods in Excel whom i know. he works in our company UK Branch and if he resigns
hahaha company will shut that process. you can guess how much he must be
earning. i myself in Capgem and earning good money.(thank
ActiveWorkbook.Names
z = ""
Sheets(4).Cells(i, 1) = x.Name
z = Replace(x.RefersTo, "=", "")
Sheets(4).Cells(i, 2) = Replace(z, "$", "")
i = i + 1
Next x
End Sub
On Tue, Mar 22, 2011 at 11:02 PM, hanumant shinde
wrote:
Thanks again.
Thanks again.
@ STDEV
sorry but ur code is not working its throwing error for Cells(r, 2) =
nm.address(false, false). i dont know if i need to make any change in your code.
@All,
i have just started working on NameRanges so dont have much idea about it.
I face 1 more problem which is as follo
Worksheet/workbook
hi ashish
the same will work in 2003
--
Thanks & Regards
Thamu
On Sat, Mar 19, 2011 at 1:56 PM, ashish koul wrote:
try this (excel 2007) i haven't tested it on 2003
>
>
>press f3 and click on paste list
>
>
>
>
>
>
>On Fri, M
Hi friends,
i want to find out all the namedranges from worksheet / workbook. can somebody
please help me.
eg. lets say A1 to A4 name of the range is range1
lets say B1 to B4 name of the range is range2
lets say C1 to C4 name of the range is range3
lets say D1 to D4 name of the range is range4
A = "The Big Brown Dog"
A = Split("The big brown dog jumped over the lazy fox", " ")
Erase A
A = "Jumped over the Lazy Fox"
hope this isn't too confusing.
Paul
From: hanumant shinde
To: excel macros
S
Hi friends,
when we declare array is it must to give () i mean parantheses.
can i declare array as dim arrayabc or i have to say dim arrayabc()
i know that if we dont write any value in () its ok. but i am not sure if we
can
declare array without ()
--
Hi Friends,
in one of my applicaiton in the office i saw variable is used as Variant. lets
say dim A as Variant.
more than 1 values are stored in it. please see the below.
dim firstrow , lastrow , dummycolumn as double
these values (firstrow , lastrow , dummycolumn) are derived by doing somethin
also pls tell me if dim abc is array then
does dim abc is equal to dim abc() ?
From: hanumant shinde
To: excel macros
Sent: Tue, 15 February, 2011 1:38:21 AM
Subject: Array or Variant ???
if i seclare variable like this
dim abc
is this array or variant
if i seclare variable like this
dim abc
is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared
like this and i thought these are variants but after going through paul's mail
chain i guess those are ar
gt;
> subtotal/total, can we hide them when taking print out?
>
>With regards,
>Usha
>
>
>
>
>On Sat, Jan 29, 2011 at 4:56 AM, hanumant shinde
>wrote:
>
>Hi,
>>
>>attached is the file which has ur solution (Hopefully).
>>it has some c
1 - 100 of 156 matches
Mail list logo