Trying to return data using array

[Rokn]

So, I have this huge data set which has caused me to have to use arrays. I'm still a new and learning user, but I really do think this is the best solution for my problem. I have sheet one as my rollup sheet and sheets 2-5 have data on them representing quarterly numbers. My problem is figuring out how to offset the data one cell to the right of where the original data goes and I thought I had it figured out, but I think I need to define a dimension for one or all of the variables that represent where I want the data to go. I've tried just about everything, but I think I'm missing something simple, yet fundamental. When I put in a message box to return values for the cell variables I wish to drop data in, it returns the data that's already in there, and the offset works, but for some reason, that's all I can get it to do. It will not for the life (or death, if I cannot figure this out soon) of it put the sum'd values in those cells, just keeps looking at them and the data that's already in them. PLEASE HELP before I go insane! I'm going to put the last iteration of my code in here, but I have a simpler build which might be easier to look through to identify the problem, which I'll drop in below that. BUT I'M killing my sanity right now just trying to think about what I'm doing wrong. Below, I've included the code(s).

Please Login or Register  to view this content.

The simpler code set is as follows:

Please Login or Register  to view this content.

[protonLeah]

At the top of your code, you have:

balCel = Sheet1.Range("Q3").Offset(0, rtrnOff), but you did not declare the variable balCel, so balCel is holding the value of the data in the cell at the offset from Q3.

It seems that you are trying to use balCel (and the rest) as names (pointers) for cells. To do that you need to modify your code such as:

Please Login or Register  to view this content.

Then to write data to the cell:

balCel.Value = rtrnBal

[Leith Ross]

Hello Rokn,

Help us to Help you...

You should post a copy of your workbook for review. Please change or redact any information that is personal or confidential before you post.

Please tell us in detail what results you expect and include before and after examples of your data.

If you have any error messages, please include them in your post and mark the line in your code where the error occurred.

[Rokn]

This worked great! I can't believe I hadn't thought of that. This got is just like I needed. You win my hero of the day award. THANK YOU, THANK YOU, THANK YOU! My sanity has officially been saved!

[Rokn]

Yes, it's been a while since I've visited the forum, thank you for the reminders. I'll try to be more clear and include spreadsheet mock-ups in the future.