Need to declare a cell as numeric in macro
Solved/Closed
amit
-
6 Jul 2010 à 06:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jul 2010 à 19:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jul 2010 à 19:01
Related:
- Need to declare a cell as numeric in macro
- How to delete a cell in word - Guide
- How to run a macro in excel - Guide
- Run macro on opening: worksheet, workbook - Guide
- Excel multiple lines in one cell - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
6 Jul 2010 à 19:01
6 Jul 2010 à 19:01
You have to put cell validation. See help on validation
