Excel Macro: Print the value of a specific row with variable columns

Question

I'm trying to print out a certain row based on a column that can be anything, and I was trying to use something like this:

'Gets me the Title(Top of Column) of whatever cell was changed
    If Worksheets("Testing Sheet").Range("A2").Value = "" Then

        Worksheets("Testing Sheet").Range("A2").Value = Range(Target.Column & ("7")).Value
    Else

        Worksheets("Testing Sheet").Range("A1").End(xlDown).Offset(1, 0).Value =  Range(Target.Column & ("7")).Value
    End If

I thought using something similar to this would work as you see above in my code:

Range("H" & Target.Row)

which seems to work for that case, but when I try to do a specific row I get the error "Method Range of Object_Worksheet failed". Hopefully it's a very easy fix that I just don't know about

Community · Accepted Answer · 2017-05-23 12:12:38Z

1

Range cannot be used with absolute row and column numbers use Cells(Row,Column) instead

Cells("7", Target.Column)

To get the Address and Value of the changed cell, use Target.Address and Target.Value respectively

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Aug 6, 2014 at 13:20

Ravi Yenugu

3,8885 gold badges43 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ganda Over a year ago

Yeah, I didn't realize it was such a simple question. I always try to give as much detail as possible, but thanks for the advice. Definitely should have been simpler. Thanks for the help though. It worked.

Collectives™ on Stack Overflow

Excel Macro: Print the value of a specific row with variable columns

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related