Replace Excel Formulas with Values Through Code

I generated some values for an exercise program. The Excel worksheet thus had cells with formulas, while some cells had the figures used to arrive at the final results. I wanted to get rid of these intermediate figures, but that would mean the final results would get affected as well. So I recorded a macro and then modified it and came up with the procedure below. The comments explain what is happening at each step. I hope you find it useful. Sub ReplaceCellValueWithSelf() ‘ ‘ ReplaceCellValueWithSelf Macro ‘ Macro recorded 25-06-2014 by Abraham. ‘ ‘ Dim intMyValue As Integer, i As Integer, j As Integer For j = 1 To 80 ‘ Do this for 80 rows For i = 1 To 5 ‘ do this for current column up to the 5th intMyValue = ActiveCell.Value ‘Read the existing value (which could be the result of a formula) ActiveCell viagra a 50 mg.Value = intMyValue ‘ Place the value in the same cell (replacing the formula) ActiveCell.Offset(0, 1).Activate ‘ move to the (same row,) next column Next i ‘restart procedure for the new column ActiveCell.Offset(1, -5).Activate ‘ move one row down and to the 5th column to the left (i.e. back to starting column) Next j ‘restart procedure for the new row End Sub Here is a modified version of the procedure that works down one column then goes to the next one. Sub ReplaceCellValueWithSelfAcross() ‘ ‘ ReplaceCellValueWithSelfAcross Macro ‘ Macro recorded 25-06-2014 by Abraham. ‘ ‘ Dim intMyValue As Integer, i As Integer, j As Integer For j = 1 To 80 ‘ Do this for 80 columns For i = 1 To 5 ‘ do this for current row up to the 5th intMyValue = ActiveCell.Value ‘Read the existing value (which could be the result of a formula) ActiveCell.Value = intMyValue ‘ Place the value in the same cell (replacing the formula) ActiveCell.Offset(1, 0).Activate ‘ move to the next row, same column Next i ‘restart procedure for the new row ActiveCell.Offset(-5, 1).Activate ‘ move to the 5th row upwards (i.e. back to starting row) and one column to the right Next j ‘restart procedure for the new column End...

read more

Magic Action Box (No) Support

After attempting to set up Magic Action Box, I sent an email to the address given on their web site. Three weeks later, I have not seen a reply. I went to the plug-in page on WordPress.org and found: <img class="alignnone size-medium wp-image-71" src="http://www.owentechkenya.com/wp-content/uploads/2014/05/Magic-300×289 vente en ligne viagra fr.jpg” alt=”Magic” width=”300″ height=”289″ srcset=”http://www.owentechkenya.com/wp-content/uploads/2014/05/Magic-300×289.jpg 300w, http://www.owentechkenya.com/wp-content/uploads/2014/05/Magic.jpg 308w” sizes=”(max-width: 300px) 100vw, 300px” /> So it seems there is a problem with the support of this plug-in. UPDATE: One of the authors responded within minutes of my posting on WordPress.org. However, his response did not fully address the problems I had mentioned. Related Items Posts Attempting To Set Up Magic Action...

read more

Attempting To Set Up Magic Action Box

This is an email I sent to the authors of the Magic Action box WordPress plug-in. —- I have been trying to show an opt-in form under a WordPress blog post. When writing the post, the options appear under the post saying I can show the Default form below my post, but nothing appears after publishing.   When I go to New Action Box and click OptIn form, it opens one of my pages to edit.   So, the plug-in has not worked at all. I am using WP 3.8 viagra prix maroc.2 Please advise. — Let’s see if they will respond....

read more