Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I tryed to make the macro exit if there has been written text in range D4:D53, but not succeed. can anyone help please? Sub Add_hours() Application.ScreenUpdating = False ActiveSheet.Unprotect Password:"" Dim r As Range Dim v As Range Set v = Range("D4:D53") Set r = Range("F4:F53") If Range("D4:53")HERE IS MY PROBLEM!!! Then GoTo errorline Else: GoTo line1 line1: r.FormulaR1C1 = "=RC[-2]+RC[-1]" r.Copy Range("E4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False r = "" v.FormulaR1C1 = "0" GoTo Lastline errorline: MsgBox ("Kun tall") Lastline: ActiveSheet.Protect Password:="", DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I prevent a long string of text from wrapping in a text fil | Excel Discussion (Misc queries) | |||
Create macro to calculate data range for a running chart | Excel Worksheet Functions | |||
Sometimes range calculate doesn't work in macro. Why? | Excel Programming | |||
TO TOM OR KEN: macro to calculate selected range | Excel Programming | |||
prevent recalculation of random data except in a "Calculate" macro | Excel Programming |