fixed range

I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set. The beginning of the...

I have a form control button I am trying to use to delete a range of cells and refill, but I do not want the formula references to shift if I add rows/columns. I am aware of naming the range but I cannot think of an appropriate way to apply that fix in this scenario. Ideally I would like to do...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m new to the forums, but looking for a little help.<o:p></o:p> I have a huge spreadsheet with various Reference Numbers, and a line of balance. I am trying to add a numerical sequence to the...