Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MACROS EFFECTED BY TABLE FORMATTING IN 2007
I have a few macros linked to a table of data. I upgraded to 2007 excel, and
when I used the 'format as table ' option to get a neater looking table, and then again try to use the macros...the macros start to work but stop 1/2 way through and ask me to debug. What am I doing wrong? All macros work on excel 2007 before I usde the format as table option. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MACROS EFFECTED BY TABLE FORMATTING IN 2007
Select Debug, which will take you to the offending line of code. Then
post that sub or function here so that people can figure out what's going on with it. On Dec 18, 7:40 am, spudsnruf wrote: I have a few macros linked to a table of data. I upgraded to 2007 excel, and when I used the 'format as table ' option to get a neater looking table, and then again try to use the macros...the macros start to work but stop 1/2 way through and ask me to debug. What am I doing wrong? All macros work on excel 2007 before I usde the format as table option. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MACROS EFFECTED BY TABLE FORMATTING IN 2007
Thanks for your suggestion. This is what the code says :
Range("A1:CB95").Sort Key1:=Range("BD1"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal I dont speak any of this lingo, so I really dont know where to start. Grateful for any advice of course. Thank you. "ilia" wrote: Select Debug, which will take you to the offending line of code. Then post that sub or function here so that people can figure out what's going on with it. On Dec 18, 7:40 am, spudsnruf wrote: I have a few macros linked to a table of data. I upgraded to 2007 excel, and when I used the 'format as table ' option to get a neater looking table, and then again try to use the macros...the macros start to work but stop 1/2 way through and ask me to debug. What am I doing wrong? All macros work on excel 2007 before I usde the format as table option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and macros | Excel Discussion (Misc queries) | |||
Excel 2007 and Macros | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Enable macros in 2007 | Excel Discussion (Misc queries) | |||
My hyperlinks are adversely effected when I insert new rows. | Excel Discussion (Misc queries) |