error message, probaly by not defining things :/

**Ammers93** · 03-23-2017, 08:11 PM

hi,

i have this code for converting a webpge into an excel document, then i can apply a bunch of autofilters on the copied data to manipulate it...i am fairly new to VBA, but using this project as a way to learn it...

i have an issue with warning messages....the one at the moment is with when i am defining last row.....originally there was one lastrow dimension, but created 2, 1 for each sheet, as that was giving me an error. that error then dissappeared and replaced it with

"object variable or with block variable not set"

i have 2 sheets, both named objects as SI and TR, SI is where the raw webpage goes to to get converted, then i extract the filtered data, paste it into the sheet TR which is the cover, and will e used by people....code is as follows:

Please Login or Register  to view this content.

**ferday** · 03-23-2017, 08:23 PM

what's SI and TR? (worksheets, right? they aren't defined anywhere, at least in the code you've shown)

Dim SI as Worksheet, TR as Worksheet
Set SI = Sheets("sheetname")
Set TR = Sheets("sheetname")

**Ammers93** · 03-24-2017, 02:20 PM

Thanks for your reply!!

The worksheets are named (in object properties, in the first row you can change the object name to refer to it in code. i got this when looking at someone elses code for something really complex)

When I follow your advise ferday, it errors the "Dim SI as Worksheet". it says duplicate declaration in current scope

Attached is how I named the sheets

SI named.png

**sintek** · 03-24-2017, 02:52 PM

Hi there Ammers93

Adding images does not help unfortunately...Text not readable. Preferably either enter the entire Code or upload a sample worksheet. This will increase our chance of success.