Results 1 to 6 of 6

Using Named Ranges in Formulas

Threaded View

neshev Using Named Ranges in Formulas 09-03-2012, 01:39 AM
Gervie Re: Using Named Ranges in... 09-03-2012, 02:01 AM
Trebor76 Re: Using Named Ranges in... 09-03-2012, 02:45 AM
neshev Re: Using Named Ranges in... 09-03-2012, 02:56 AM
Trebor76 Re: Using Named Ranges in... 09-03-2012, 07:44 AM
Cutter Re: Using Named Ranges in... 09-03-2012, 01:20 PM
  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    NJ, US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Using Named Ranges in Formulas

    Hi,

    is it possible to use a named range myrange = A1:A5, instead of just one cell, in the following code so the calculations are performed to each cell in the range?

    Sub GetIntegerPart()
    Dim myvalue As Double
    Dim IntValue As Integer
    myvalue = Range("a1") * 10
    IntValue = Fix(myvalue)
    Range("a1") = IntValue / 10
    End Sub
    Thank you
    Last edited by Cutter; 09-03-2012 at 01:20 PM. Reason: Added code tags

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