Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell,
searchvalue = reportsheet.Range (”C2”) .Value
this works fine if the content in “C2” is exactly right, but I’m using for ref numbers...