Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help with an if then else macro
If Sheets("data Worksheet").Range("H26") 0 Then Range("H26").Select Else Range("BA1").Select Application.CutCopyMode = False Selection.Copy Sheets("Test Database").Select Range("F9").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False What I am looking for is to have H26 on the data worksheet displayed on the Test database worksheet. But with this macro the H26 cell on the test database worksheet is being copied on to the same sheet but in a different place. Why? Can anyone help? Eric |