Microsoft Office Forums - View Single Post - [Solved] Message Box to advise corrective action required

Thread: [Solved] Message Box to advise corrective action required

View Single Post

Old

02-19-2017, 02:02 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Could be as simple as...

Code:

Sub Look_At_A37()
    If Len(Range("A37")) > 1 Then
        Range("C15").Value = Range("A37").Value
        Range("C16").Value = Range("A38").Value
    End If
End Sub

Reply With Quote