cellslr

  1. R

    insert cellls vba

    Hi Guys I have the following code Cells(LR, 28).Value = txtCNum4.Value In my useform txtCNum4 is a text box name Lease Period What i want is when the user enters a number let's say 10. vba inserts 10 cells after Cells(LR, 28) and i also want vba to add a heading month1 to month10 to...
  2. B

    Sum VBA

    Using the following code to Sum columns 12 through 18, however the totals are incorrect, not sure what I am doing wrong. Code I am using For i = 12 To 18 lr = Cells(Rows.Count, i).End(xlUp).Row If lr > 12 Then Cells(lr + 1, i) =...
  3. B

    sum column vba

    This is an additional question from a previous post. I received the following code, however when using in a different worksheet it is not working well. I am trying to place a total row (sum) and format this row. Possibly bold font & fill The range is D5:Lxx). Column 12 may expand. Dim lr As...
  4. H

    Macro to delete all rows, except those containing text BRFM

    I have code to delete all rows in Col C from row 4 onwards except whre the text contains BRFM for eg BRFM REDIT I am struggling with this part below If Cells(LR, 3) <> Like "BRFM*" Then Sub Delete_Unwanted() Sheets(2).Select Dim LastRow As Long Dim LR As Long 'fetch the count of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top