I am tring to align the test in the cell but it no workie and it is driving me nuts
$RangeValue = "J1"; $Alignment = "xlCenter"; $Working_Alignment = $Book->Worksheets($SHEET_NAME); $Working_Alignment ->Range("$RangeValue")->{HorizontalAlignment} = "$Alignment"; I get this error and I do not know why? Unable to set the HorizontalAlignment property of the Range class Win32::OLE(0.1603) error 0x80020009: "Exception occurred" in PROPERTYPUT "HorizontalAlignment" at D:/apps/XML_2_EXCEL_DRIVER/v001.004/ Modules/proc_data.pm line 306 _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs