Copying a cellvalue, and use it in VBA?

[AndreasWalseng]

Hi, i were wondering how i can copy a numbervalue from B4 in sheet called Dimensjonerende kriterier, and use this value to specify a starting point for a copy command
i'm using match formula in B4 to get the Y-reference to were that is, and going to copy in x-y position from that starting point

below is my VBA so far.

Please Login or Register  to view this content.

[davsth]

I think you need to explain a little more for example
in B4 is the value 7
so in column G of the Ark2 sheet I wish to paste in G7

Please Login or Register  to view this content.

unless it is similar logic for the cell you are copying from Range("A" & startrow).Copy Worksheets("Ark2").Range("G5") it is not quite clear

[AndreasWalseng]

in Cell B4 i have a match formula that checks the name in B3 with the list in "Ark1" Cell A:A
and returns a numbervalue.
i need the code to use this value when copying from a location in Ark2
added my excelsheet if this helps-


Attachment 770386
Attachment 770387

[davsth]

whats wrong with post 2?

[AndreasWalseng]

read the first statement as a request to clarify what i ment and thought the code was just a quote . sorry works great, however one question.

Please Login or Register  to view this content.

how can i add a boundry to the "G" & startrow? normaly you can define a range like A1:B6.
as i need to copy from
Attachment 770398

[davsth]

Your attachment is not valid when i try to open it so a bit in the dark, so the below is a guess. Something along these lines

if you know the columns wont change but the rows will
Range("B" & startrow &":G"& endrow) for example

or something like Range(Cells(5, 6), Cells(7, 8)).Select will select f5:h7 it can be replaced with variables

Range(Cells(startrow, startcolumn ), Cells(endrow, endcolumn)).Select

you can call the variables by whatever names you wish

[AndreasWalseng]

Thanks sir, it works like a charm.
however i have another issue, whenever i copy with VBA the index/match formula goes I/T? what is the reason for this?
Attachment 770424

[davsth]

Your attachments are invalid. the post 3 with a spreadsheet is ok, but everything that says attachment doesn't open. So I can not offer any help as I can't see anything!

Why not attach as post 3 and refer to the specific cells that are causing a problem.
When copying do you wish for the formula to be copied or just its value?

[AndreasWalseng]

Got it working, thanks for your help sir!