+ Reply to Thread
Results 1 to 8 of 8

Getting the content of cells in a row ABOVE a selected range..in VBA

  1. #1
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Getting the content of cells in a row ABOVE a selected range..in VBA

    Hi,

    I have coded the following procedure and where I get to NomAction I am not entirely sure how to get the contents from the cell for Each Action..

    The idea is I have a spreadsheet with certain NAMES above the content in each column.. but I do not include this row above the data range I select for Ensemble Actions... How can I get it? The string value that is in the Cell above the first cell of my range in the column?
    You'll see it in the spreadsheet here. In Actions are the titles in the first row. I want those to appear under Fonds in the sheet Analyse Statistique..

    https://docs.google.com/file/d/0Bwjh...it?usp=sharing

    How could I do that?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    What exactly are you trying to refer to?

    The cells above what?

    Which of the 13 modules is the code in?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    Try this.
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    wrong file sorry, it is in module no.2 here: https://docs.google.com/file/d/0Bwjh...it?usp=sharing

  5. #5
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    It worked, thanks!!

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    Glad it worked.

    Can I ask if you are having problems attaching files here?

  7. #7
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    No, hehe, I like alternating between google docs and this upload.. plus google docs lets me remove later certain files I wouldn't like around the web (parts of my project)

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Getting the content of cells in a row ABOVE a selected range..in VBA

    Well it's a bit of a pain having to download from google, I can't do it without logging in.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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