cells calculation

  1. N

    Format cells option for a cell in an excel

    I have a column as ZIP code based out of USA that can have maximum length as 5. If I give 11, then it can take 000 as predecessors and become 00011. I tried formatting cells option but that has options to make it 0011 or 000-11 or 000000011. I am not getting options to make 00011. Any leads on...
  2. K

    VBA Cells(Rows.Count,"A").End(xlUp).Row & Other counting

    Hi I am trying to ascertain worker caseloads for workers within the service for which I work by using the below; Sub CommandButton1_Click() Dim a, b, c, d, e, f, g, h As Integer Dim CC, LB, KC, TH As String Dim LstRw, Rw As Long Sheets("Recovery Caseload").Select LstRw = Cells(Rows.Count...
  3. S

    How to fully qualify all Cells() references

    Greetings, When I run this macro on its own it executes correctly: Sub StateBIPDData() Dim sheet_name As Range For Each sheet_name In Sheets("WS").Range("B:B") If sheet_name.Value = "" Then Exit For Else With Sheets(sheet_name.Value)...
  4. B

    What's wrong with my code? (cells reference and calculations)

    Hi, the following code runs OK from within a simple macro. But when run triggered from a command button click, it hangs at the line in Bold font below. Can anyone tell me what is wrong? The purpose of this code is to replace certain rows (row 16 until last row) of each column with a new date...

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