{"id":6883,"date":"2021-11-22T00:36:17","date_gmt":"2021-11-22T00:36:17","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=6883"},"modified":"2021-11-22T00:37:03","modified_gmt":"2021-11-22T00:37:03","slug":"solved-compile-error-from-vba-editor","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/compile-error-from-vba-editor\/19144.html","title":{"rendered":"Solved Compile Error From VBA Editor"},"content":{"rendered":"<p>&nbsp;<\/p>\n<div>\n<p><iframe loading=\"lazy\" src=\"https:\/\/web.archive.org\/web\/20201026191818if_\/https:\/\/www.computing.net\/img\/screencast\/play.html#392700-132\" width=\"480\" height=\"270\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<div>Problem with formula?<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<table width=\"100%\">\n<tbody>\n<tr>\n<td>I tried to use the formula listed on the July 26, 2010 from Humar and when I got to the + Range (&#8220;B1&#8221;). Value I got the following message: Compile error: Expected: line number or label or statement or end of statement and the data was in RED. Can you help me figure out what the problem is?<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":1},"question-category":[53],"question_tags":[],"class_list":["post-6883","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/6883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=6883"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=6883"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=6883"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=6883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}