Convert range format to number

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Convert range format to number

07-28-2018, 04:22 PM

jeffreybrown jeffreybrown is offline

Windows Vista Convert range format to number

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

You forgot the variable to establish the last row

Code:

Range("K2:N" & LastRow)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format a range of cells	Dave T	Excel Programming	1	06-01-2016 08:58 PM
How to format a TOC (level 1) using a number, but have the number hidden in the text	porpoiseoil	Word	1	09-13-2014 12:53 PM
IF statement - number range	irhut	Mail Merge	1	02-11-2014 11:20 PM
Change from General Format to number format	gbaker	Excel	3	08-16-2013 01:04 PM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.