| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct way to call active worksheet?
Hello,
What is the correct way to call upon the active worksheet? I want my code to call the active worksheet (ActiveSheet) that I am currently in, rather than calling up a certain sheet by name as I am doing below: Private Sub CBWP_Click() Worksheets("BIDWORKUP").Range("B48").Value = "Waterproofing" Worksheets("BIDWORKUP").Range("H48").Value = 1.45 Worksheets("BIDWORKUP").Range("B62").Value = "Waterproofing" Worksheets("BIDWORKUP").Range("H62").Value = 1# End Sub Help! LB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to call a worksheet (as a function) | Excel Discussion (Misc queries) | |||
| Altering code to reference the worksheet before the active worksheet | Excel Programming | |||
| Call macro from active workbook-duplicate shortcut keys | Excel Programming | |||
| Call VB6 DLL from Worksheet without VBA wrapper | Excel Programming | |||
| macro to apply worksheet event to active worksheet | Excel Programming | |||
Threaded Mode
