UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Code Not Working    
 
   
John_Ross
post Apr 3 2012, 12:08 PM
Post #1

UtterAccess Veteran
Posts: 332
I’ve vba that works fine , except I want to include a Sum value of the range E7:E100 in the worksheet – Sheet1. I used the following vba but it’s giving me error:

Range(“F11”).Value = SUM(“E7:E100”)

What is worng with this line?
Go to the top of the page
 
+
 
 Start new topic
Replies
Bob G
post Apr 3 2012, 12:11 PM
Post #2

UtterAccess VIP
Posts: 8,140
From: CT
as mentioned by Isaac in your other thread Copy Excel File.

CODE
ThisWorkbook.Worksheets("Sheet1").Range("A1").Value="Text"
Go to the top of the page
 
+

Posts in this topic
- John_Ross   Code Not Working   Apr 3 2012, 12:08 PM
- - Bob G   as mentioned by Isaac in your other thread Copy Ex...   Apr 3 2012, 12:11 PM
- - ipisors   Drop the quotes around e7:e100   Apr 3 2012, 12:12 PM
- - ipisors   Technically, you would need to use: Range(“F11”)....   Apr 3 2012, 12:17 PM
- - John_Ross   When I drop the quotes, the line turns red.   Apr 3 2012, 12:17 PM
- - ipisors   sorry, see my edited response   Apr 3 2012, 12:18 PM
- - John_Ross   The new formula worked! Thank you.   Apr 3 2012, 12:19 PM
- - ipisors   You have some weird kind of quotes in there. Repl...   Apr 3 2012, 12:19 PM

« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 02:38 AM