Use Variable as Row Number?

**Joseph9098** · 05-25-2018, 01:16 AM

I need my VBA script to use a variable pulled from the row number of the shape I click on to reference individual cells in that same row

Please Login or Register  to view this content.

Gives me the row number of the clicked shape, but how do I incorporate that to select a cell?

Please Login or Register  to view this content.

does not use the rn variable as the row number

**bakerman2** · 05-25-2018, 01:23 AM

Try this one

Please Login or Register  to view this content.

Also, it's safer to Dim rn as Long instead of Integer because Long can handle larger numbers.

**Joseph9098** · 05-25-2018, 01:42 AM

Hey thanks bakerman2 that was a huge help! Now how do I set the value of cell A1 equal to that of the newly selected cell?

HTML Code:

This did not work at all.

**bakerman2** · 05-25-2018, 01:56 AM

It should be

Please Login or Register  to view this content.

**Joseph9098** · 05-25-2018, 02:30 AM

I guess typos tend to happen when programming late at night

Thanks bakerman2!

**bakerman2** · 05-25-2018, 02:49 AM

Late at night ??? It's early in the morning here.

Glad to help and thanks for rep+.

Re: Use Variable as Row Number?