Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel VBA
Name: imtiaz Date: March 10, 2004 at 07:56:04 Pacific OS: 2000 CPU/Ram: 256
Comment:
Hi friends I have a code which is working properly. I have 31 sheets and I have to Change the sheet No(from 1 to 31) on every sheet. My requirement is that this code should be written only Once in my file.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
c = ActiveCell.Column r = ActiveCell.Row
If c > 1 Then c = c - 1 End If
If ActiveCell.Column = 2 And ActiveCell.Value = "" And Sheet2.Cells(r, c) <> "" Then ActiveCell.FormulaR1C1 = Time End If
End Sub
Plz Plz tell me the solution. I will be very thankful to u.
Name: Report_2 Date: March 10, 2004 at 16:16:03 Pacific
Reply:
I do not know your answer but I do know that you are using the worksheet property instead of a workbook property so your macro is limited to the worksheet.
If you do not receive an acceptable answer to this query here I recommend you post it at the Ozgrid Excel/VBA forum board as it specialized in such questions. They are very good.
Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both ...
Summary: I have failed to find a comprehensible method of writing data to a serial and parallel port on a PC using Excel VBA. I wish to send control code (ESC/P2 codes) to an Epson dot matrix printer and send ...
Summary: Hi All, I want to take a loan. Following are the input details: 1) I want to pay EMI max upto 5000 per month 2) Terms in months = 60 (5 years) 3) Interest rate = 15% reducing balance method I want to ...
0 
