Search results for query: *

Hello Conner, I have a silly question, but worth to ask.... When you opened the you get a message box asking you if you wanted to Disable or Enable Macros.. And of course did you click on Enable Macros? Also you may want to check your Macro Secuity Selection.. If its on high...

Hello BHranek, You may want to try the following: Sub TransferActiveItems() Dim rgLast As Range Dim lLastRow As Long, i As Long Dim wsOrigSheet As Worksheet Dim wsDestSheet As Worksheet Dim sIName As String Dim vINumber As Variant Dim dSDate As Date, dEDate As Date 'assign the 2 worksheets...

Hello Everyone, Is there any code out there to use on Excel.... to press a command button that would pull up the Printer Window Que? thnx Tony Tony813

Hello vaneagle Maybe by changing the following on your code: If c.Interior.ColorIndex = Light_Yellow Then nCol = c.Column nRow = c.Row Result = msgbox("The cell is at col " & nCol & " and row " & nRow, , "It Works!!")...

I want to open Access 97 through Excel. the mdb file has a password... and all i want to do is pull up a form from that database. Could anyone provide some code... thank you tony_813 Tony813

Hello Everyone, Does anyone have any code..... To open Access Database through Excel... The Database is password protected.. thank you Tony813

You are the man.... you have answered... the mystery.... to my question... thank you... thank you.... Tony813

Working with Access: and the following is my problem: ElseIf Tip.text = &quot;&quot; Then <---------------Something abut this line here... MsgBox &quot;Please Enter a Tip&quot; Me.Tip.SetFocus I change the code using the value property. I dont get the error msg. However, it...

Hello 4335, You have the For Loop option: For i = 1 To 2 'Indicates the row number Cells(i, 1).Value = Myvalue Next i tony813 Tony813

hello ... Maybe this will give you an idea: Sub test() UserEntry = InputBox(&quot;Enter Time&quot;) Result = TimeValue(UserEntry) Worksheets(&quot;Sheet1&quot;).Range(&quot;A1&quot;).Value = Result End Sub Tony813

Hello Everyone... I came across this User Defined Function to retrive the UserName from Windows XP: Public Declare Function getUserName Lib &quot;advapi32.dll&quot; Alias &quot;GetUserNameA&quot; (ByVal lpBuffer As String, nSize As Long) As Long Public Const MAX_BUFFER_LENGTH = 100 Public...

Hello IanJE... Maybe.. a combination of formulas would help.... Try: =&quot;Years:&quot;&(YEAR(A2)-YEAR(A1))&&quot; Days: &quot;&DATEDIF(A1,A2,&quot;d&quot;) Example: A1: Has the start date 1/12/2001 A2: Has the end date 12/2/2002 A3: Has the formula above.... This would result: Years: 1...

Hello...althea.. you may use the SUMIF FUNCTION EXAMPLE: COLUMN 1 COLUMN 2 JOHN 5 JOHN 4 TONY 1 CINDY 1 =SUMIF(A1:A4, &quot;JOHN&quot;, B1:B4) GIVIES YOU THE RESULT 9 THIS IS THE SYNTAX: SUMIF(range,criteria,sum_ranng) Hope this...

Hello... I was just passing by.... ... and yes I'm new... ...however, I thought I would say...thnx to bearjam... ...His posting.. allowed me to learn something new... Tony_813