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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: thumbtwiddler
- Content: Threads
- Order by date
-
range = range.value query
Wondering if anyone can help. Have searched through and struggling to find this. Going through some old proformas removing copy / paste values in the code and replacing with application.range("X") = application.range("Y").value to speed them up. My problem is when (in the above example), X is...- thumbtwiddler
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Ctrl & PgUp/PgDwn not functioning on locked sheet?
Hoping someone can help me here as I'm a bit confused and I'm sure I'm missing something simple. Essentially, on a multi-tab file, my code protects and unprotects the sheet quite a lot but when it's protected, the Ctrl & PgUp or PgDown stop functioning correctly, as in doesn't move tabs but...- thumbtwiddler
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Tracing a library
Hope someone can help, bit of a noob question. Have tried hunting it out but my search-fu is obviously weak! I've got an xla I've unzipped and gone through the code. I'm trying to find 3 functions but am unsure how to find the function with the user32.dll to see what it does. Can anyone...- thumbtwiddler
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
