Hi Rajesh,
Set the worksheet calculation mode to 'Manual' and it works fine for
you.
Tools -> options ->
Select the Calculation tab
Select Manual and say OK.
If you feel, you need to update the calculations at any point of time
in worksheet, press F9.
Cheers,
Lohith
On
e("A1")) <> "H" Then
Target.Previous.Select
End If
End If
End Sub
Cheers,
Lohith
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-m
Hi Shah,
Please provide the details, what you excatly need.
This will help you to solve your issues quickly.
cheers,
Lohith
On Feb 13, 8:53 pm, SHAH DARSHIL wrote:
> I need help mentioned in attached file.
>
> Can any one suggest logic for same?
>
> regards,
> Darshil Shah.
Hi,
Try the below code.
Sub test()
Dim bdt As Date
Dim edt As Date
Dim Weekends As Integer
bdt = "02/06/2009 19:44:31"
edt = "02/09/2009 10:13:41"
Weekends = GetWeekends(bdt, edt)
MsgBox ((edt - bdt) * 24) - (Weekends * 24)
End Sub
Function GetWeekends(DateFrom, DateTo)
DF = DateFrom
DT
Hi Tobi,
Try the below code. Add a reference to 'Microsoft scripting runtime'
before using the code.
Sub CreateFolderStructure()
Dim fsoobj As FileSystemObject
Dim rootpath As String
Dim rootfold As Folder
Dim fold As Folder
Dim subfold As Folder
Dim num As Integer
Dim subfoldtext As String
num
Hi Alok,
Try this command :
Environ("UserDomain")
Cheers,
Lohith
On Jan 6, 10:16 am, Alokeshwar Tiwary
wrote:
> Is there a way to retrieve domain name using vba...? I need this to make sure
> that my vba tool will run only within the network of my compay.
>
&
ot;.xls") Then
wb.Activate
Exit Sub
End If
Next
End Sub
'Example to check the Activateworkbook Procedure.
Sub chk()
Activateworkbook ("Book2")
End Sub
Cheers,
Lohith
On Dec 15, 7:11 am, Abhijat wrote:
> Hi Group,
> I was wondering if there is a way
Hi Chris,
Try this array Formula and let me know if it work out for you..
=SUM((MONTH($B$1:$B$19)=MONTH(AA1)) * ($C$1:$C$19="P"))
Remember to add this formula using Ctrl+Shift+Enter(Array Formula).
Cheers,
Lohith
On Dec 12, 2:33 am, Chris Salcedo wrote:
> I need to count da
Hi Larry,
Try Using this formula instead.
=DATE(B4,B3,B2)-DATE(D4,D3,D2)
Cheers,
Lohith
On Dec 5, 12:51 am, larry <[EMAIL PROTECTED]> wrote:
> I am trying to creat a code for caculating the number of days between
> two dates. N=A-N causes a type mismacth run time error. Also looki
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:2
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:2
Hi Sanjay,
Check out these links. It would help you.
http://www.cpearson.com/excel/sortws.aspx
http://exceltip.com/st/Sorting_Sheets_in_Ascending_Order/669.html
Regards,
Lohith
On 27 Nov, 23:13, "Sanjaykumar Bhola" <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> Can an
12 matches
Mail list logo
