KenCubs


I have a VBA variable, x, whose value is the address I want to put in an Excel spreadsheet formula. Does anyone know how to do this

Thanks,

Ken




Re: In VBA, putting formula on spreadsheet

Ben McBen


range(x).formula = "=rand()"

re-reading you might mean

range("A1").formula = "=" & x