By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

run time error 13, type mismatch

P: 1
Hi,

I have just joined. I am getting a message when I am running a macro - run time error '13', type mismatch. when I am debuggung it it opens up my VBA code and shows this:

Sub Updategraph()
'
'
' Macro recorded 10/01/2006 by Ajay Dahiya
'

Dim i As Integer
Dim j As Integer

j = 0

Sheets(" Data").Select
Range("G5").Activate

For i = 0 To 31

If ActiveCell.Value <> "" Then - this line is highlighted in yellow colour

j = j + 1

ActiveCell.Offset(1, 0).Activate
May 6 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
might check for null

If not isnull(ActiveCell.Value) or ActiveCell.Value <> ""
May 6 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Technical questions should not be posted in the Introductions forum. I am moving this to the Access forum.

ADMIN
May 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.