LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Problem to calculate cells

Hi,
I have a macro wicht is putting in a cell a formula vlookup(....). But Excel does not calculate it, I have a #Name error until I click on it. I have ask excel to calculate the cell but it doe not change anything. I am working with Excel 2000. Is it a bug of excel 2000 or is there a way to obtain than excel calculate it ?
Thanks for any help and happy new year.
Benjamin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with a function to calculate weighted test score Drew P. Excel Worksheet Functions 2 September 17th 09 12:55 PM
UDF To Calculate Work hours between two dates Problem with code jlclyde Excel Discussion (Misc queries) 4 August 13th 07 06:47 PM
calculate problem in excel Ohmega Excel Worksheet Functions 5 July 8th 05 12:06 AM
HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" robert Excel Worksheet Functions 1 May 22nd 05 06:03 PM
excel calculate problem, (try to refer to defined names?) CornElvis Excel Programming 1 November 18th 03 03:55 AM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"