Variable number or rows

Hi there,

I really need some expert help

Please Login or Register  to view this content.

If anyone is able to help let me know and I will PM the link of the sheet - dont know if you can post links on this forum.

Right, in cells above A16 there is this code =A16-$I$11 and above that it would be =A15-$I$11 and above that =A14-$I$11 and that works fine.

A16's forumla is =(I6-((I9)*I5))/((I7*I8)-((I9))) and that works perfectly.

But, anything below A16 should be =A16+$I$11 then A17=A16+$I$11.

But whenever I enter in that formula it changes everything below A16 TO =X-Y, when it shouls be positive and it skips a few cells for example in A18 it states =A19-$I$11 when it should be =A17+$I$11 and countinue that pattern all the way downwards.


Thank you,
bamboozled.

Welcome to Excel forum!, you can attach a workbook here for folk to see what you are doing, when makin a post before submitting it scroll sown to manage attachments click it and attach your workbook then submit!

bamboozled,

Welcome to the forum. Please take a few minutes to read the forum rules below.

I've done the following for you

1). Removed the urgent in title
2). Added code tags

Can you please do the last thing yourself and add the link to the other excel forum where VoG has giving you this code

Many thanks

VBA Noob

PS That does sound link i made that /\ I didnt, the legend called VoG made it for me. THough I felt I was nagging him so I made another thread for it (asked him like 30 times for diffrent codes - seriously). I genuienly apologise for my mistake. Mr excel.com is where he was helping me but I felt really really guilty for asking so many Q's- because believe me I did. I even PM'd vog a couple times and not once did he complain.

SORRY VBA NOOB and everyone else I am just soooo stressed right now trying to sort this out while revise for 3 exams on the same day!

Erm yeah VoG even told me how to upload it. This link is here:

http://www.box.net/shared/gsbqjmqud0

Sorry again,
Thank you.

/\ sorry about all the SP mistakes, no time to correct them lol

Not looking for a sorry just for you to follow the rules (again...see link below) and add the link to the other forum otherwise post will be closed

VBA Noob

I solved it!

http://www.mrexcel.com/forum/showthread.php?t=351959

Why delete the link and replace with solve it.

Care to mark as solve and post you're solution for others

VBA Noob