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 Sub

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.

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

Web Hosting

We offer or facilitate web hosting with the following reliable web hosts.
These hosting accounts are especially suitable for small organisations and for individuals.
The support offered is excellent and is available 24 hours a day, so you need not know much about web hosting to use the services.

ICDSoft

 

responsive_wp_468x60

read more

Domain Name Registration

You may register your very own domain name with us! A domain name is something such as owentechnologies.com, that people use to access your web site.

We have two offers as follows:

Domain Name Only (This is for our clients in Kenya only)
You may register a domain name only (without web hosting).

  • We will develop one free home page for you
  • We will create for you one free email address @ yourdomain.com

This may be suitable for you if you still do not have your web site ready, but you want to be found on the Internet.
Please contact us if you wish to take up this offer.

If you have a credit card, then you can register your domain name for yourself right away at NameCheap. Please click the image below and follow the instructions to do so.

Namecheap

Domain Name with Web Hosting
You may register a domain name as you order web hosting.

Your domain name will cost less than if you registered the domain name without hosting
You will of course get all the benefits of our web hosting packages, such as web space for your entire web site and unlimited email addresses.

read more