Syntax for visible range between two columns to last row

I want to color a range between two columns, to the last row. Columns are figured via the macro, but I don't know how to use that info to set the range object.

Below are the pertinent pieces of my code as it currently exists, with my offending line in red. Any help I can get in straightening this one out is highly appreciated.

Please Login or Register  to view this content.

Since you did not show your entire code I will assume there is a With statement indicating the sheet reference. With a little analysis we can observe that your case is 1 to 12 and that your column is sequential and 7 more than MFRmo. The red line that you indicated is flawed in many ways so I rewrote what I think you are trying to accomplish

Please Login or Register  to view this content.

Sorry for not showing the whole code; It's pretty long, I'm trimming as I can. We're working on the Activesheet.

I apprecaite the shortend Select statement. On the definition of Proj, it's actually Column T, so I need to get the range from after Result through column T. I'm starting to work with your syntax to see how that works. I'll post results in a few minutes.

I just noticed that this line will also error

Please Login or Register  to view this content.

Change it to this:

Please Login or Register  to view this content.

As a side note, are you sure this part is doing what you want it to do?

Please Login or Register  to view this content.

Since Result is now a numerical value, this line is problematic

Please Login or Register  to view this content.

Given arbitrary values Result = 12 and LastRow = 35 The code would be equivalent to this

Please Login or Register  to view this content.

See the issue?

Another thing. Is Proj always column T? If it is there is no need for a variable. Lastly, I do not know why the the line is erroring. It looks ok to me but without an example workbook there is no way to tell what is causing it. Best of luck.

Thanks Stynkynts.

Yes, Proj is always T. I've done a rethink, and simplified the issue. My variables are MFRMo and Proj. MFRMo is my last column with expenses; Proj is my first month that I'm making a projection for. So H:MFRmo is my expense range, Proj:S is my Projection range. I determine MFRMo and Proj on a different sheet (my user has to select the month they're making a projeciton for, so I put in a simple formula to calculate my variables based on their selection). My updated code is below. My next task is to figure our the formulas to plug in for calculating my fields, so you might see another post if I run into an issue there. Thanks so much for tackling this one with me.

Please Login or Register  to view this content.