Malik Aap Gr8 ho…
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Wednesday, June 15, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)
कविता : दास्तान-ए-VLOOKUP
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे दोनों गजब होनहार.
खासियत दोनों गुणी बेटों का है, कुछ इस प्रकार.
पहले बेटा VLOOKUP Excel की
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
Target
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 H8.
Thanks so much. I'll give both of those a try.
On Tue, Jun 14, 2011 at 8:07 PM, ashish koul 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 14, 2011 at 8:4
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 wrote:
> Hi,
>
> I know this can be done because I've seen it before. I have to login
> to a web-sit
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.
--
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 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 can really be.
>
> Take a
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 wrote:
> hello,
>
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: excel-macros
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.
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 (hrs
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 :
http:/
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
http://blogs.technet.com/b/heyscriptingguy/archive/2005/03/22/how-can-i-
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 wrote:
> Hi Experts ,
>
> Pls check the attached file .In it
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
--
---
Dear Amit,
Please see attached sheet..
--
Thanks & regards,
Noorain Ansari
On Tue, Jun 14, 2011 at 6:38 PM, Amit Gandhi 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 and 2nd is its com
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 file
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 Linke
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:
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut2(cText As String, file As String) As Integer
On Error GoTo
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 try
Thank you very much its working fine. :)
On Fri, Jun 10, 2011 at 10:43 PM, GoldenLance wrote:
> Just add .CurrentRegion immediately after With objArea
>
> so
>
> Sub CurRegLoopHighLightBorderTopBot()
>
>Dim objArea As Object
>
>For Each objArea In ActiveSheet.UsedRange.SpecialCells(2).Ar
22 matches
Mail list logo