1. kelly mort

    VBA code to locate intersection of a row and a column

    I have these two variables: 1. MyRow 2. MyColumn I am identifying them with an input box entry So if myrow becomes A2 and mycolumn becomes F1 , then I am looking for a code to get that intersection (F2) for me. I will be placing some data at the intersection. But I don't know how to get the...
  2. M

    How to convert VBA IF formula into R1C1 format

    Hi, Quick question as I just can't figure it out, please can someone show me how to convert the following into R1C1 format: MyColumn in this case is where I have a cell selected - in this case I have selected a cell somewhere in Column A but in the future, I might select Column F or Z etc etc...

Some videos you may like

This Week's Hot Topics