Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

D[_6_]

external usenet poster

Posts: 34

Overflow Problem

Hey guys-
Got this code from the net, seems to work fine until now. I'm getting an
Error 6 Overflow problem. I don't understand VB much at all, so can someone
point me along the way?
Thanks
D

Sub Step4()
' ProperCase Macro
Dim c As Range
With ActiveSheet
For Each c In .UsedRange
c.Value = Application.WorksheetFunction.Proper(c.Value)
Next
End With

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Overflow when translating from C++ HELP!!	hunting	Excel Programming	6	April 24th 04 08:18 PM
overflow error	ExcelMonkey[_5_]	Excel Programming	6	January 22nd 04 02:34 AM
Overflow in VBA, but value < limit	Brad[_13_]	Excel Programming	3	December 11th 03 04:16 AM
VBA overflow	Tom Ogilvy	Excel Programming	3	September 2nd 03 09:04 PM
VBA overflow	Don Guillett[_4_]	Excel Programming	2	September 2nd 03 04:19 PM

All times are GMT +1. The time now is 12:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us