VBA code to filter a column from a cell reference in a different worksheet

[dlamle]

I am wanting to create a filter for just Column AG in a worksheet titled "Darren" based off cell C8 in a worksheet titled "Control Sheet". The cell I want to reference is a value.

Below is the VBA code that I am currently using but every time I run the Macro is returns a message saying "Compile Error: Syntax Error" . Hopefully someone can help me out!

Sub Darren()
'


' Darren Macro
'


'
ActiveSheet.Range("$AG$2:$AG$2000").Autofilter Field:=33, Criteria1:=Worksheets("Control Sheet").Range("C8").Value.

 

[JoeMo]

If you want to filter col Ag and your range is in AG then the field is 1.
Try:

Range("$AG$2:$AG$2000").AutoFilter Field:=1, Criteria1:=Worksheets("Control Sheet").Range("C8").Value

 

[dlamle]

Great catch!

I made the adjustment but am still getting the same error message

 

[JoeMo]

Great catch!

I made the adjustment but am still getting the same error message

The line I posted produces no syntax error - did you try copying it directly from your browser and pasting it to the VBE window?

 

[dlamle]

I did and yes it fixed the issue, thank you!

Now the next step, I want show numbers greater than or equal to C8.

Currently I have this code

Range(">=C8").Value

 

[JoeMo]

I did and yes it fixed the issue, thank you!

Now the next step, I want show numbers greater than or equal to C8.

Currently I have this code

Range(">=C8").Value

You are welcome.

Range(">=C8") is not a valid range object. Try

Range("$AG$2:$AG$2000").AutoFilter Field:=1, Criteria1:=">=" & Worksheets("Control Sheet").Range("C8").Value

 

[dlamle]

It worked, I appreciate your help so much! Thank you

 

[JoeMo]

It worked, I appreciate your help so much! Thank you

You are welcome - thanks for the reply.

 

[tannerboudrero]

Hi i'm new to VBA and i'm trying to auto filter data on a sheet titled "Forecasts" by referencing cell A3 on a sheet titled "Sheet1".I'm unsure how to code this from start to finish. Any help anyone could give would be much appreciated! Thanks!

 

[dlamle]

What is the range of your data in the "Forecasts" tab?? And what column are you wanting to filter on it?