How to programmatically (VBA macro) set the contents of a cell to be a formula ?

**rex99** · 12-10-2012, 10:22 AM

How would I programmatically (within a VBA macro) set the contents of a cell to be a formula ?

For example, I know I can set a cell to the contents of a string, by doing

Please Login or Register  to view this content.

I tried something like

Please Login or Register  to view this content.

but that of course didn't work.

The formula

Formula:

Please Login or Register  to view this content.

works for me, but I want to be able to programmatically place it in a cell, while incrementing the cell references in the formula ... IE: E11, F11 .... E12, F12, .... E13, F13 .......

Thanks

**watersev** · 12-10-2012, 11:24 AM

example for A11:A19

Please Login or Register  to view this content.

**MarvinP** · 12-10-2012, 11:31 AM

Is this what you want?
http://msdn.microsoft.com/en-us/libr.../ff838835.aspx

**rex99** · 12-11-2012, 08:16 PM

I tried the watersev suggestion and that does almost what I want.

I have this function below - that works - except of course for adding the formulas.

Please Login or Register  to view this content.

Thanks

**jimmalk** · 12-11-2012, 09:18 PM

Hi Rex. I recently had a similar issue about programatically putting formulas into ranges. I may be giving you an incorrect suggestion, but 2 points I found was that the cell recieving the formula sometimes (seemingly somtimes, not always) must be set to the General cell format. Also, tag on ".formula" to the code. IE.

Please Login or Register  to view this content.

I fixed your qoutes a little also, you had some errors there. Don't know if this fixes your problem for sure. Maybe?

**watersev** · 12-12-2012, 05:43 AM

@rex99

Put this instead of commented block in the posted code of yours

Please Login or Register  to view this content.

**rex99** · 12-16-2012, 08:15 PM

That worked - thanks

How to programmatically (VBA macro) set the contents of a cell to be a formula ?

LinkBack

Thread Tools

Rate This Thread

Display

How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Re: How to programmatically (VBA macro) set the contents of a cell to be a formula ?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions