Subscript out of range

[pvzshark]

Good day all. I am getting an error subscript out of range. I know why i am getting it, I just need your help to bypass it.

I am importing data from mysql. Financial year vs last year financial year. but being in April the may, June July etc months does not exist for this year so i need to ignore it.
Below is wehre i do calculations for the columns 40 and 41. but they do not exist with this import but might for a future import. How do i if exist then else ignore?

ActiveSheet.ListObjects("Table_pastel_12_cust_rank").ListColumns(40). _
TotalsCalculation = xlTotalsCalculationSum

ActiveSheet.ListObjects("Table_pastel_12_cust_rank").ListColumns(41). _
TotalsCalculation = xlTotalsCalculationSum

 

[Snakehips]

If everything else is independent of these two lines then maybe just ignore the error?

On Error Resume Next
ActiveSheet.ListObjects("Table_pastel_12_cust_rank").ListColumns(40). _
TotalsCalculation = xlTotalsCalculationSum

ActiveSheet.ListObjects("Table_pastel_12_cust_rank").ListColumns(41). _
TotalsCalculation = xlTotalsCalculationSum
On Error Goto 0

GHope that helps.

 

[Fluff]

Cross posted
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites where you have asked this question.

 

[alansidman]

deleted

 

[pvzshark]

AAAHHHHHH - did not know the 2 sites are connected, different usernames in the 2, thats why. Now I know.

 

[Fluff]

They are not linked & you have already been made aware of this rule on at least three different sites in the past. So there is no excuse.
Please supply all relevant links.

 

[pvzshark]

Fluff calm down. geesh. cant remember its mr excell and o ja. here it is.

subscript out of range. I know why i am getting it

Good day all. I am getting an error subscript out of range. I know why i am getting it, I just need your help to bypass it. I am importing data from mysql. Financial year vs last year financial year. but being in April the may, June July etc months does not exist for this year so i need to...

www.excelforum.com

how is excelforum and mrexcel linked? i do not understand this at all?

 

[pvzshark]

So I am not allowed to as on mrexcel and Excel Help Forum which is 2 different sites with 2 different usernames? Please explain why as I am confused. BTW subscript out of range. I know why i am getting it was helped already. thanks

 

[Fluff]

You have (yet again) posted the same question to more than one site, without supplying links. If you do not understand what cross posting means try reading this

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

www.excelguru.ca

 

[pvzshark]

How about stop sending links to read and and and be a bit helpful as a moderator and explain n laimans terms?