Referring to a range of cells inside a formula in VBA Excel -

-

i'm trying use vba in order calculate fields. when record macro this:

activecell.formular1c1 = "=averageif(r4c[-27]:r4c[-6],2012,rc[-27]:rc[-6])"

the problem range formula can change.

i have integer variable numofmon counts required columns formula first column on sheet. formula above however, uses offsets determine required range because range can change need use numofmon in order use required cells. how can change formula can use properly?

i tried using variables this:

a = 28 numofmon = 21  activecell.formular1c1 = "=averageif(r4c[-(a-1)]:r4c[-(a-numofmon-1)],2012,rc[-(a-1)]:rc[-(a-numofmon-1)])"

but error: "application defined or object defined error"

basically

activecell.formular1c1 = "=averageif(r4c[-" & (a-1) & "]:r4c[-" & (a-numofmon-1) & "],2012,rc[-" & (a-1) & "]:rc[-" & (a-numofmon-1) & "])"

Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more