LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Yes, I'm an idiot...But I cannot seem to divide two values in VBA see below

Obviously I'm a ultra newbie to this. I tried searching this group and
find stuff that is close, but not what I need. If fear that I am
looking for something that is so easy, that everyone else has figured
it out. Hence, I cannot find the right solution.

See below for the oh so eloquent abortion of code that I have brought
together.

Dim span As Range
Dim divisions As Range
Set span.Value = Worksheets("Sheet1").Range("G20")
Set divisions.Value = Worksheets("Sheet1").Range("E20")
Set answer.Value = span.Value / divisions.Value
Worksheets("Sheet1").Range("J20").Value = answer.Value

Now that I have the masses writhing in pain from my stupidity, could
someone rectify the situation for this dolt.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to divide all values with a fixed value ? fax Excel Discussion (Misc queries) 2 November 21st 05 07:12 PM
divide values by 10000 danielpaval New Users to Excel 2 October 6th 05 04:57 PM
dummy alert - divide values by values Micayla Bergen Excel Discussion (Misc queries) 1 May 4th 05 02:16 AM
How do you divide all values in the worksheet by 1000000 me Excel Worksheet Functions 1 April 25th 05 04:29 AM
Divide Expression stops in Macro when Can't divide JUAN Excel Programming 6 May 6th 04 07:05 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"