Hello Deepak
While trying to figure out how to post everything you need, I found a
solution to my problem. By trial and error, I stumbled on a VBA code
solution that works as follows;
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit
Application.EnableEvent
PFA
Is this what you are looking for. If not send an example file.
Regards
Deepak
On Thu, Aug 1, 2013 at 10:26 PM, RJQMAN wrote:
> I am not sure if this is the proper way to reply, so forgive me if I am
> not doing this correctly. I thought I posted the code but perhaps I did not
> do it corre
I am not sure if this is the proper way to reply, so forgive me if I am not
doing this correctly. I thought I posted the code but perhaps I did not do
it correctly.
My cell formula was simple in column C - I just use Isnumber to check and
make sure that there was a number in both column A and Co
Just trying to imagine with your problem since there is no file attached
to explore the other scene.
PFA my first approach, is that close with your ?
Pada 01/08/2013 8:54, RJQMAN menulis:
I have a complex program I wrote in Excel 2003 about six years ago,
and I am working to update it. In the
I have a complex program I wrote in Excel 2003 about six years ago, and I
am working to update it. In the program, I am concerned about the sum of
data entered into two columns and totaled in the third column. There are
about 60 groupings of cells, all independent, with about 25 sets of cells