VBA properties not coming after dot

[MAHAVISHNU]

Dear All,

I have few doubt in VBA. when ever I write the VBA code i am getting Auto Properties list after dot(.). for some cases i could not the list while writing the code. but there is no error. even if I run the code I am getting the result. there is no error in code. But why the Auto properties not coming some times. this make me lot of trouble which very difficult to fin the properties.

Here i have few sample code.

in the below code I set the source worksheet. now i want to set the range from the source sheet. when I enter the code i am not getting the range properties after dot.

please clarify what i have missed in VBA procedure.

Sub pivot_test_2()


Dim source_st As Variant
Dim pivot_st As Variant
Dim pt As PivotTable
Dim start_rng As Variant
Dim data_rng As Variant


Set source_st = ThisWorkbook.Sheets(3)
Set pivot_st = ThisWorkbook.Worksheets(9)


set start_rng=source_st.


End Sub

thank,

Regards,

C.Mahavishnu

 

[RoryA]

You have declared source_st and pivot_st as Variant, so the compiler doesn't know what properties apply to them - they could be anything. You should declare them as Worksheet objects.

 

[wideboydixon]

You've declared everything as a Variant so you don't get autocomplete. Change the declarations to be strongly typed e.g.

Dim source_srt As Worksheet
Dim pivot_st As Worksheet
Dim pt As PivotTable
Dim start_rng As Range
Dim data_rng As Range

WBD

 

[wideboydixon]

Of course, I'm just following @RoryA around like a little puppy today ...

WBD

 

[RoryA]

Who's a good boy?

 

[MAHAVISHNU]

Thank u very much. now it is coming.