Calculating Range does NOT calculate entire range ?

charlie79 · Mar 20th, 2002, 08:52 AM

I am calculating a range of cells through vba code ,Range("D49:BX66").Calculate. This code runs on a combobox change event. Problem is, there are 3 particular rows that do not calculate while the rest of them are. These 3 rows are doing calculalations on the other rows that are calculating. What it is actually doing is calculating those 3 rows for the values that were in the other rows before the combobox change event ocurred. Any following this? I hope so cause it very aggravating. Right now, I am doing the, Range("D49:BX66").Calculate in another subroutine that is called from the combobox change event. Please help...

charlie79 · Mar 20th, 2002, 12:57 PM

I'm going to try again... Someone, please?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 08:52 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	I am calculating a range of cells through vba code ,Range("D49:BX66").Calculate. This code runs on a combobox change event. Problem is, there are 3 particular rows that do not calculate while the rest of them are. These 3 rows are doing calculalations on the other rows that are calculating. What it is actually doing is calculating those 3 rows for the values that were in the other rows before the combobox change event ocurred. Any following this? I hope so cause it very aggravating. Right now, I am doing the, Range("D49:BX66").Calculate in another subroutine that is called from the combobox change event. Please help...

Mar 20th, 2002, 12:57 PM	#2
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	I'm going to try again... Someone, please?