Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to run a Macro to ....
Hello,
I need to run a macro on all the Cells of a sheet to run the PROPER function on each cell and if the length of that Cell is zero to stick a blank space " " inside the cell. Thru Help I find a sample and by simple modification I inserted into my macro but deoes not work and gives me run time error 1004. Here is my sample code: Sub FixUp() Dim myRange As Range Set myRange = Worksheets("PtTable").Range("A1:AA500") myRange.Formula = "=Proper()" End Sub Would you please help me on my problem? -- Jeff B Paarsa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |