Need help with VBA copying selected range of row data

You have event code in Sheet3 code module that will call Macro3 code in code Module2 if the target cell = "Print". It then will copy whatever is selected to the next available row, based on column A content, of Sheet2.

What do you want it to do? Do you want it to copy the entire row or just certain range of cells?

Originally Posted by JLGWhiz

You have event code in Sheet3 code module that will call Macro3 code in code Module2 if the target cell = "Print". It then will copy whatever is selected to the next available row, based on column A content, of Sheet2.

What do you want it to do? Do you want it to copy the entire row or just certain range of cells?

Hi JLGWhiz,
Yes thats right. Right now as attached above, it is working the way I wanted as click on the print text, it will copy the row base on my formula on the print text cell which i'm using hyperlink reference to highlight those cell(it should copy the same row of the print text that you clicked. Not sure how to code it in vba so i uses hyperlink reference) and run macro for the copying and pasting steps.

But it is very buggy which i mention about on the 2 problem I face. Like the keyboard up down left right button between the cell with print text will trigger it. And also it triggers when you click on the CELL with the print text instead of the mouse hovering to the print text word clicking on it which resulted the copying of rows will only copy that particular cell itself which is the print text word. Thus ended up pasting the print text word instead of the row data into sheet2.

Please Login or Register  to view this content.

The reason it is only copying the single cell when you click on that cell is because the copy macro uses 'Selection' as the range reference. So it is copying the single cell that you select. I am not sure how to resolve your problem, because what you describe as your procedure seems to be erratic.

Hi JLGWhiz,

Thanks for the explanation. I see the issue with the selection.copy.

Is there any way to copy the row of the print text that is being clicked so that it copys that row of selection.
Example if I choose to click on print text at column D7, i want to copy the data at row 7.

I'm currently using hyperlink reference as an alternative because i'm not sure how to code for VBA. If a VBA code can be written, I will remove that hyperlink reference.
Appreciate the help!

If you always want to copy the entire row then in your Macro3 code chang

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

If you do that, then you will not be able to copy just the selection of anything less that a full row.

Originally Posted by JLGWhiz

If you always want to copy the entire row then in your Macro3 code chang

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

If you do that, then you will not be able to copy just the selection of anything less that a full row.

Hi JLGwhiz,

Thanks for quick reply and help! It's slightly better now.

Just 1 more question, can I know is there anyway to prevent it from triggering when using keyboard up down left right key around the print text cell or clicking on the cell? Can I make it to trigger only when clicking on the word itself.

Originally Posted by finalazy

Hi JLGwhiz,

Thanks for quick reply and help! It's slightly better now.

Just 1 more question, can I know is there anyway to prevent it from triggering when using keyboard up down left right key around the print text cell or clicking on the cell? Can I make it to trigger only when clicking on the word itself.

You are using the 'Worksheet_SelectionChange' event to trigger the macros when the target (selected cell) = "Print". If you are using the arrow keys to maneuver the pointer, then anytime you move to a cell that equals "Print", you are going to trigger the code. The only way I know to not trigger it is to avoid those cells which contain the word "Print".

Originally Posted by finalazy

Hi JLGWhiz,

Once again thanks for the clear explaination. I will use other method instead of Worksheet_SelectionChange. Thanks for the guidance and I appreciate it.

Happy to assist,
regards, JLG