Receiving following error “Complie error : syntax error” Help

**masond3** · 11-01-2012, 10:14 AM

hey guys

This is my vba code, but i am getting the following error “Complie error : syntax error”

any ideas ?

Please Login or Register  to view this content.

**masond3** · 11-01-2012, 10:18 AM

Please find attached work book

Hope this helps

**JosephP** · 11-01-2012, 10:32 AM

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

note the code tags which you ought to be familiar with by now ;-)

**masond3** · 11-01-2012, 03:12 PM

hi joseph

thank you for reply

i am new to vba, so this is a learning curve for me

random q, i have built a pivot table in sql, can this pivot be populated in excel via vba ?

**JosephP** · 11-02-2012, 10:19 AM

no idea what you mean-how have you built a pivot table in sql?

Re: Receiving following error “Complie error : syntax error” Help