+ Reply to Thread
Results 1 to 2 of 2

Take the value of the selected cell and multiply it by 1.5923566 and enter it..

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-02-2003
    Location
    Birmingham, UK
    MS-Off Ver
    Office 365
    Posts
    127

    Take the value of the selected cell and multiply it by 1.5923566 and enter it..

    I have a report which I receive daily where some values need to be manually adjusted by 1.5923566.

    What I would like to do is hit the cell with the value in it and then hit a button with a macro that will multiply the value in the cell by 1.5923566 and then replace the original value with the new value.

    Is there a way of doing this simply please ?
    Terry

    "... I thought I was a power user of Excel until I came onto these boards..."

  2. #2
    Forum Contributor
    Join Date
    11-02-2003
    Location
    Birmingham, UK
    MS-Off Ver
    Office 365
    Posts
    127
    I've tried to write a routine but it doesn't work. Here's what I've done so far...

    Sub UpdateUSDollars()

    ActiveCell = *1.5923566
    Selection.Copy
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    End Sub

    Any help received would be much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1