HI I am new to VBA world. I am trying to create a macro for my excel sheet. Everything is working fine except I can not use a variable as lookup value in the macro.