Search results for query: *

Hi! i am trying to do when i click the option button shuld not allow to enter in range the below what is wrong in it. is it possible? Private Sub OptionButton60_Click() Dim RngPST As Range Set RngPST = Sheets("Sheet1").Range("A14:A600") Sheets("Sheet1").Range("A14:A600").Value = "" End Sub

Hi! i have excel form 8 to 40 rows find the specific column which put tick mark when it has left column has numbers with screen, if it matches put tick mark in that specific oolumn for exampl Mar.2 mar4, mar.12 there are three column find mar.12 column put tick mark if the mar.4 has number with...

Skip thanks in advance i have code grab everything on screen till end of report but my code grab <<<< this too coudl you help me thanks her eis the code ------------------ *** END of report ****...

skip this is the code i am using , when i step through it works fine but when it runs it keep on going ascenind gorder and descending order 48,47, 46, 45 becasue of j = j -1 coudl you help me. thanks ------------- For j = 7 To 48 DSFPT1 = Trim(UCase(MyScreen.GetString(6, 9, 6))) DSFPT =...

Skip I am searching a word 'Total"in report there are three totals i want only third total with corresponding value this search first total here is the code For j = 5 To 41 dfst = Cells(j, 1).Text if dfst = MyScreen.GetString(1,15,5) then If dfst <> "" then do Set MyArea =...

hi! i am trying to figure it out earlist starting time and latest finished time here is the code. but i could not find out max and min thanks in advance. ***************************** If Right(JobName, 1) = "*" Then For j = 1 To 16 ''' If...

i find row and column may be 54 or may be 55 how do i put it here. Trim(MyScreen.GetString(MyRw, 54, 5))

Hi! i am checking against excel to screen if account matches in screen corresponding value into excel the below code works fine, but it takes more than half an hour. is it fastest way to do that? thanks in advance Do For i = 2 To 3000 Account = Cells(i, "E").Text MyScreen.MoveTo 4, 15...