Selecting most of a row

[gwithey]

How would i go about selecting a row to the left of any active cell. As far as column B

Please Login or Register  to view this content.

i tried this but it selects the whole row to the left

[jasoncw]

Try:

Please Login or Register  to view this content.

HTH

Jason

[Shijesh Kumar]

Please Login or Register  to view this content.

[gwithey]

Thank you

Do you know how i would use it in this code

Please Login or Register  to view this content.

Month Column = 14 at this point (is Variable)

[gwithey]

Forgot to say it needs to calculate from MonthColumn variable(14) back to column(B)

And give the total

[jasoncw]

Are you trying to create the correct SUM formula? If so, this may be what you are looking for:

Please Login or Register  to view this content.

HTH

Jason

[gwithey]

Im afraid the code didnt work

I need a total for columns "B" to the one before "MonthColumn"(variable)

And need rows 4 and 7-16 filled as shown in my macro

The amount of columns is dynamic rows are not. I tried xlToLeft and such but havent been successeful

George

[jasoncw]

Hi George.

Once you run the procedure I listed above, what are the formulas in the cells? What "didnt work" about the procedure?

Jason

[gwithey]

Error 1004 Object Error on row

Please Login or Register  to view this content.

[gwithey]

It does add a total heading to row B4

[jasoncw]

When the error is presented, what is the value of MonthColumn? You can see this by clicking Debug, then hovering the cursor over the variable MonthColumn.

[gwithey]

MonthColumn Is 12 at error

It pastes the Total heading in the correct place. which is a good sign. The rest should follow

I defined i As Integer Is this wrong may cause an object error.

George

[jasoncw]

Interesting... See if this works:

Please Login or Register  to view this content.

If not, is it possible you could post up a copy of your workbook?

[gwithey]

Thats Great thanx, it worked successfully and added the column after the variable column number.

I forgot to mention the average column so i just updated that and it now works.

Please Login or Register  to view this content.

Than you for your time

George

[jasoncw]

Glad it worked, George.

By the way, you should move the average formula after the loop, or it will insert the formula 9 times. (Move it between Next i and End With).

Jason

[gwithey]

Yep i know what you mean didnt think about that

Please Login or Register  to view this content.

George