Syntax Correction: Combine text with variable

**cazooo** · 05-08-2009, 04:44 PM

I have the following VBA code and try to sum the range from B2 to CY2 for DA2; then B3 to CY3 for DA3, etc. Therefore I use the for loop. It results in "Application defined or Object defined error".

Could anybody help me to correct the syntax?

-----------------------------------------------------------------------

Please Login or Register  to view this content.

**shg** · 05-08-2009, 04:47 PM

Please read the forum rules, and then edit your post to add code tags.

**shg** · 05-08-2009, 08:33 PM

Thanks.

This may fix the first line; I'm not sure what you're tring to do with the second.

Please Login or Register  to view this content.

**cazooo** · 05-08-2009, 08:44 PM

Thank you, it's solved. Actually it should have Range in between to sum from cell B2 to cell CY2 and the result should be pasted to cell CZ2 as shown in the code.

Please Login or Register  to view this content.

**shg** · 05-08-2009, 10:36 PM

I question whether you don't want the average instead of the sum over a constant, which is subject to error.

Syntax Correction: Combine text with variable

LinkBack

Thread Tools

Rate This Thread

Display

Syntax Correction: Combine text with variable

Re: Syntax Correction

Re: Syntax Correction: Combine text with variable

Re: Syntax Correction: Combine text with variable

Re: Syntax Correction: Combine text with variable

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions