+ Reply to Thread
Results 1 to 5 of 5

Altering line of code to reflect a variable.

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Altering line of code to reflect a variable.

    How would I alter the following code:

    Please Login or Register  to view this content.
    To have "BD524" replaced by a string variable called "bRange" I have made several attempts to alter it but I continue to get an error no matter what I try.

    -Ken

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Altering line of code to reflect a variable.

    Try this;
    Please Login or Register  to view this content.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Altering line of code to reflect a variable.

    I think you are asking for something more along the lines of:

    Please Login or Register  to view this content.
    Design everything to be as simple as possible, but no simpler.

  4. #4
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: Altering line of code to reflect a variable.

    Yes! Thank you Stormin!

  5. #5
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Altering line of code to reflect a variable.

    Happy to help!
    If that takes care of your original question, please select Thread Tools from the menu link above to mark this thread as SOLVED.
    To say thanks to the user(s) who contributed towards the solution, you can use the "Add Reputation" button on their helpful post(s).
    Thanks!

+ 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. [SOLVED] Need Help altering my VBA code.
    By danbates in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-19-2017, 09:31 AM
  2. [SOLVED] Altering Pivot with variable pivotfield name
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-17-2016, 02:41 PM
  3. Horizontal and vertical scroll bar and a time line to reflect todays date
    By JamesJoshua in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2016, 12:36 PM
  4. What does this line of code mean? Variable Date/Opening Files
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2015, 11:34 AM
  5. [SOLVED] Altering a calculation based upon variable values from a drop down list
    By situationroom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 06:04 AM
  6. Quick question regarding line break within code & variable within prompt box
    By jasondu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 12:06 PM
  7. Altering this macro: Insert copy of line in same place on 2 sheets!
    By gangel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-16-2012, 04:10 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