Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sub Button4_Click()
Sheets("Calculations").Select Dim curdate As String Dim predate As String curdate = Range("F18").Value predate = Range("F17").Value Workbooks.Open Filename:= _ "S:\ New\New Business All.xls" Range("C3").Select ActiveCell.FormulaR1C1 = "predate" Range("D3:G3").Select ActiveCell.FormulaR1C1 = "curdate" This is the beginning part of a macro, if I have €œ around predate and curdate they show as those words, when I dont they get put as 0. Currently the values of these are April in F18 (curdate) and March in F17 (predate) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Concatinate a filename | Excel Discussion (Misc queries) | |||
close form code | Excel Discussion (Misc queries) |