+ Reply to Thread
Results 1 to 2 of 2

Macro to Range Value specific columns

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,637

    Macro to Range Value specific columns

    I have a macro to copy data in B9:M9 and to paste these as values in B9 onwards


    Where “Current” appears in row5 for e.g. B5, then the column containing Current must not be copied and pasted as values. In this eg only C9:M9 to be copied and pasted as values in C10 onwards


    It would be appreciated if someone could kindly amend my code


    Please Login or Register  to view this content.

    I have also posted on https://www.mrexcel.com/board/thread...-data.1149818/
    Attached Files Attached Files
    Last edited by Howardc1001; 11-10-2020 at 01:56 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,835

    Re: Macro to Range Value specific columns

    Seems it is now solved (or well on the way) at MrExcel.
    So please mark thread here as SOLVED
    Best Regards,

    Kaper

+ 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] Getting used range from worksheet as named range for specific columns
    By jaryszek in forum Excel General
    Replies: 4
    Last Post: 08-17-2020, 04:37 AM
  2. [SOLVED] Possibility to use dynamic range while outputting range to specific columns
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2019, 09:40 AM
  3. [SOLVED] Only specific columns are hidden based on range
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-05-2017, 01:35 PM
  4. Copy specific range selection to msword but why it copies columns not in range?
    By adbasanta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2016, 03:46 AM
  5. [SOLVED] VBA to import used range of specific columns to different columns
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2014, 12:04 PM
  6. Copy a specific row and a range of columns to next available row on another worksheet
    By monkey1184 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:02 PM
  7. [SOLVED] Using specific columns of a dynamic range
    By Darren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2006, 06:30 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