View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickH NickH is offline
external usenet poster
 
Posts: 60
Default Reduce Flickering using Application.ScreenUpdating

Xiazer,

My first thought is 'why is showgrp a function?'. Without actually
testing the code I'm surprised it works at all.

The purpose of a function is to return a value based on arguments
passed to it. It is not normally capable of making changes to the GUI.

Try simply changing the Function keyword to Sub and see if that fixes
the problem.

HTH,
NickH.