Formula not filling down with pasted data

[HensonRogers]

Hello, I am hoping somebody can point me in the right direction...
In Excel 2007, I am pasting (using Paste Special, Values to maintain formatting) data into an existing spreadsheet in columns A-J, with formulas in columns K-M, which is all a named range "SWData".

The data I'm pasting in is slowly growing in rows, and when I paste it in, the formulas in column K and M fill down with the imported data, but, the formula in column L does not.

I know I could workaround this with VBA, but, if there is a way to get column L to behave like K and M, that would keep things simple!

Thanks in advance for any assistance with this.

Henson

 

[texasalynn]

Welcome to MrExcel board....

so sounds like your code is putting the worksheet into manually calc instead of automatic

take a look at this
http://www.mrexcel.com/forum/showthread.php?t=403785

 

[HensonRogers]

Thanks very much for the quick reply!

I hate to say "that's not it" since if I knew the answer I wouldn't have asked. But, there isn't any VBA code running in this spreadsheet, and the columns on either side of the offending one are working OK.

I checked the Calculations Options and it is set to Automatic.

Hmmm.

 

[texasalynn]

oops look like I posted to the wrong post. Wasn't related to yours - sorry