Results 1 to 4 of 4

NumberFormat in cells with if function

Threaded View

gajdam NumberFormat in cells with if... 01-20-2013, 04:35 PM
Norie Re: NumberFormat in cells... 01-20-2013, 04:40 PM
gajdam Re: NumberFormat in cells... 01-20-2013, 05:24 PM
Norie Re: NumberFormat in cells... 01-20-2013, 05:30 PM
  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    2

    NumberFormat in cells with if function

    Please, i cant solve this

    Sub Format_Cell_Hektari()
    If Cells(1, 1) = "ha" Then Cells(1, 2).NumberFormat = "#,##0.0000" ' ...( if Cells(1,1) not equal to "ha" then stay "#,##0.00")
    End Sub
    but i wont this macro always active in this sheet

    ps. sory my english is not so good
    Last edited by jeffreybrown; 01-20-2013 at 04:36 PM. Reason: Please use code tags...Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1