Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
detect changing cells
Hi everyone! A have a worksheet with the following data: AZ5=4 , BA5=3, BB5=2, BC5=1 in column AP , I have a function in specific cells who copies the values from above cells: AP42=3, AP47=3, AP52=2, AP57=1, AP60=1 and so on.. (about 100 cells copies data from cells above) What I want: when I...- leroiv
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
close Excel
Hi! I have a form in Access with a button with the code: Private Sub cmdPrintToWord_Click() Dim strSelect As String Dim appWord As Word.Application Dim appExcel As Excel.Application Dim doc As Word.Document Dim exlBook As Excel.Workbook Dim exlSheet As Excel.Worksheet...- leroiv
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
cell color
Hi! I have the code below : Sub PopulareCelule() Dim k As Integer Dim l As Integer k = ActiveCell.Column l = ActiveCell.Row For i = k To 35 If ActiveCell.Interior.ColorIndex = 4 Then Cells(l, i).Value = "yes" Else Cells(l, i).Value = "no" End If...- leroiv
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
