Thread: Correct way to call active worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
galimi[_2_] galimi[_2_] is offline
external usenet poster
  
Posts: 65
Default Correct way to call active worksheet?
Replace Worksheets("name_of_sheet") with ActiveSheet
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Locutis" wrote:

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



Reply With QuoteReply With Quote