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?

as mentioned by Isaac in your other thread Copy Excel File.

Drop the quotes around e7:e100

This post has been edited by ipisors: Apr 3 2012, 12:12 PM

Technically, you would need to use:

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

And yes, like Bob said, fully qualify this stuff.

ThisWorkbook.Worksheets("Sheet1").Range(“F11”).Value = " =SUM(E7:E100) "

When you start running code with users who may or may not have 2 other excel workbooks open at the same time, you'll start having weird results, if you don't fully qualify which book, which sheet, etc.


This post has been edited by ipisors: Apr 3 2012, 12:18 PM

When I drop the quotes, the line turns red.

sorry, see my edited response

The new formula worked! Thank you.

You have some weird kind of quotes in there. Replace them with regular quotes. seriously- that's what I found when I copied/pasted it into a module.