Thank you very much its working fine. :)
On Fri, Jun 10, 2011 at 10:43 PM, GoldenLance samde...@gmail.com wrote:
Just add .CurrentRegion immediately after With objArea
so
Sub CurRegLoopHighLightBorderTopBot()
Dim objArea As Object
For Each objArea In
Works for me. Put a break point onto the last line and check the array data.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Richard
Envoyé : lundi 13 juin 2011 22:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ List Box
I am
After a few days looking around, I seem to have been able to solve
this myself despite never even having heard of what ADO Streams are
before:
code starts
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut2(cText As String, file As String) As Integer
file is attached. i need formula please.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi Folks
I am finding some problem in excel formula, pls help me here. I have a excel
data in two columns, one is some job code and 2nd is its completion date in
different units. I need a formula that can show final completion date
against each job code. You can look into attached excel data
Dear Amit,
Please see attached sheet..
--
Thanks regards,
Noorain Ansari
On Tue, Jun 14, 2011 at 6:38 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Folks
I am finding some problem in excel formula, pls help me here. I have a
excel data in two columns, one is some job code
Hi Experts ,
Pls check the attached file .In it I have to protect the cells in
columns C to AG if it have any data, but the other columns for
entering name or serial number need not want to protect how can I
solve it.
Regards
Rajesh Kainikkara
--
try this
Sub Macro1()
ActiveSheet.Unprotect Password:=ashish
Cells.Select
Selection.Locked = False
Columns(C:AG).Locked = True
ActiveSheet.Protect Password:=ashish
End Sub
On Tue, Jun 14, 2011 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
Hi Experts ,
Pls check the
do you want to save your workbook in text and csv format.check links below
in text
http://www.compshack.com/visual-basic/save-file-using-visual-basic-excel-macro
http://www.vbaexpress.com/kb/getarticle.php?kb_id=805
in csv
hello,
i have a selection say(A6:H100) now i have to sort this selection by
column no 3
tx
regards
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear all,
I'm really hoping you can help me or at least answer a question that I
have regarding macros and how clever they can really be.
Take a look at the sample data below (an imagine it in an excel
worksheet):
Person ID LearnerCourse title
Date Duration
Hi,
I know this can be done because I've seen it before. I have to login
to a web-site and query some data. I have the code to get me to the
web page but I have to login. I know there is a way to write into the
macro to fill in the needed info and login.
Any assitance is greatly appreciated.
Hi Rajesh,
See whether this is what u expected Maybe I am wrong...
File attached...
Thanks,
Hariharan Tharagan
-Original Message-
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh K R
Sent: Tuesday, June 14, 2011 10:32 AM
To:
Sub sort_ascending()
' choose xlno if data is not having header
' change order as ascending or descending
Sheets(1).Range(a6:h Range(a6).End(xlDown).Row).Sort
key1:=Sheets(1).Range(c6), order1:=xlAscending, Header:=xlYes
End Sub
On Tue, Jun 14, 2011 at 7:35 PM, airen airen1...@gmail.com
can you attach the sample workbook and showing the format in which data
needs to be pasted
On Tue, Jun 14, 2011 at 7:56 PM, CIISA chowderdra...@googlemail.com wrote:
Dear all,
I'm really hoping you can help me or at least answer a question that I
have regarding macros and how clever they
Have a look at the attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : mardi 14 juin 2011 13:47
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry new
file is attached. i need formula please.
--
http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
http://www.xlmacros.com/content/how-login-website-using-vba
On Tue, Jun 14, 2011 at 8:41 PM, Don donf...@gmail.com wrote:
Hi,
I know this can be done because I've seen it before. I have to login
Thanks so much. I'll give both of those a try.
On Tue, Jun 14, 2011 at 8:07 PM, ashish koul koul.ash...@gmail.com wrote:
http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
http://www.xlmacros.com/content/how-login-website-using-vba
On Tue, Jun
I have a worksheet with dollar values in column H, beginning in cell
H8 and names in column J, beginning in cell J8. I want to use a
formula or vba code to lock a cell in column H based on if there is
data entered in a cell in column J. For ex. (if John Smilth is
entered in J8, I want to lock
try this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 And Target.Row = 8 Then
'target.column =3 because column c is no 3 column
'you can change password ashish and choose your own
ActiveSheet.Unprotect Password:=ashish
If Not IsEmpty(Target.Value) Then
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे दोनों गजब होनहार.
खासियत दोनों गुणी बेटों का है, कुछ इस प्रकार.
पहले बेटा VLOOKUP Excel की
21 matches
Mail list logo