Simple way to re-write VBA code?

[spydey]

So I have some code that I have written referencing arrays, named ranges, and ranges.

I have taken the workbook and re-designed it to be table based.

I figure I will have to re-write the VBA code to reference the table objects instead of the ranges, right?

Is there a simple way to do this or am I going to have to go line by line and re-write it to properly reference the table objects in place of the ranges/named ranges/arrays?

Thanks for your help!

-Spydey

 

[Jeffrey Mahoney]

You can still reference simple ranges in an Excel Table. Named ranges work also. When you say you're referencing arrays, do you mean arrays in VBA?

Jeff

 

[spydey]

You can still reference simple ranges in an Excel Table. Named ranges work also. When you say you're referencing arrays, do you mean arrays in VBA?

Jeff

Yes, I figured I could still reference the same ranges and named ranges, but when I redesigned the workbook to be table based, I renamed my ranges, etc.

As far as the arrays, yes they are coded in VBA.

I think I am going to have to re-write the majority of it.

Good practice for me .... just didn't want to have to re-do what took me ages ... hahaha, but I am just learning so maybe this will be a good thing.

Thanks for your input.

-Spydey

 

[shg]

hahaha, but I am just learning so maybe this will be a good thing.

Is is a good thing -- the code will be better, more organized, easier to understand.