refs

Afternoon all. Done some work on my project today and it's been going pretty well. Getting towards then end of moving data around and started inserting some formulas. The first formula went fine, it just adds/combines 2 Cells together down the columns into a new column. My next formula...

Hi all, Im not sure if this possible but any ideas would be amazing! I have a sheet that is used by a colleague of mine and she keeps accidently saving it in random places which breaks all of the external refs. Is there a way to set the sheet to only be able to be saved in one location? Im...

Hi team, Have an excel file that gets larger every time I save it. It did have circular refs in it that have now been repaired (no errors or circ ref's any more) and the file size has gone from 800kb to around 2.5mb in 3 days. Each time I save it with new data input into it, it grows around...

HI Everyone, I need to change these column refs from Letters to numbers but just cant get it right. please help the code its in is Dim r As Range Set r = Intersect(Target, [AB14:AB214,AG14:AG214,AL14:AL214,AQ14:AQ214,AV14:AV214,BA14:BA214,BF14:BF214,BK14:BK214,BP14:BP214]) If r Is...