+ Reply to Thread
Results 1 to 2 of 2

How to use variables in newly-inserted columns?

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    How to use variables in newly-inserted columns?

    Hi. Your help is needed. I have two kind of columns in my range. Original columns (a, b, c) and newly-inserted columns just to the right of each of the original (ai, bi, ci). The value (of any cell) of each newly-inserted column is the value of original column divided always by the second column (denoted p). Due to the DB size, I'm trying to use variables, but it having problems.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: How to use variables in newly-inserted columns?

    Ok, apparently the code is working now. The reason I thought otherwise caused by the fact the constant divider (denoted as p) is a rather large number (something like 800,000) so many cells throughout my range shown like 0.0000 but actually were not null but rather small, like 0.00001 for example. Anyway it works, and it looks like a rather simple yet powerful loop if one needs to solve similar tasks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba to insert new row AND highlight NEWLY INSERTED ROW
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 11:56 PM
  2. Replies: 1
    Last Post: 02-25-2013, 11:37 AM
  3. Formula to span newly inserted columns?
    By mikep7779 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2010, 09:44 AM
  4. Macro to copy some columns to newly inserted sheets
    By paul_20k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2006, 10:48 AM
  5. [SOLVED] Naming a newly inserted sheet using VBA
    By Ant in forum Excel General
    Replies: 2
    Last Post: 10-05-2005, 09:05 AM

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