I created a macro in 2007 (it works in 2003). Simply macro to create a template for a class exercise. After creating in 2007, I ried to run it and I get some errors messages. Below is the code (I copied only a small portion). The lines with the . = are in red and this is causing the macro to error out. I get a syntax error message. The first line – click on cell A3, enter the funtion =NOW() and then change the formatting to be month, day, and year. Nothing fancy….
Here is a few lines of my code:
Range(“A3”).Start
. = “=NOW()”
Range(“A3”).Start
.Borders = “[$-409]mmmm d, yyyy;@”
Range(“A1”).Start
. = “ABC COMPANY”
Range(“A2”).Start
. = “Quarterly Report”
Range(“A6”).Start
. = “Region”
Range(“A7”).Start
. = “North”
Range(“A8”).Start
. = “East”
Range(“A9”).Start
. = “South”
Range(“A10”).Start
. = “West”
Range(“A12”).Start
. = “Total Sales”
Range(“B6”).Start
. = “Sales “&chr(10)&”Amount”
With .Alignment(ErrorString := 1, Native := 13).
.Interior = “Calibri”
. = “Regular”
. = 11
. = FALSE
. = FALSE
. = FALSE
. = FALSE
.RectangleBottom = False
It seems as if my VBA editor is slicing my code. I am getting a lot of RED and sytax message. Is there something in 2007 I need to do to get my macros to work. I have class this week and I need to cover macros.
Can anyone help??
