| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print on worksheet
Hi! I have a simple problem. I want to print a certain value in on a
worksheet in a loop. For each loop I want to print on one cell below the previous one. However there is something wrong with the line below, it does not write anything on the worksheet. pls help! Worksheets("Settings").Range("a1").Offset(1, k) = strDate |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print on worksheet
You could put this line in before your line to see which cell you're
addressing: msgbox Worksheets("Settings").Range("a1").Offset(1, k).address And you could add this line to see what strDate is: msgbox strDate Or, to see the date formatted as a date, msgbox format(strdate,"mm/dd/yy") James "Arne Hegefors" wrote in message ... Hi! I have a simple problem. I want to print a certain value in on a worksheet in a loop. For each loop I want to print on one cell below the previous one. However there is something wrong with the line below, it does not write anything on the worksheet. pls help! Worksheets("Settings").Range("a1").Offset(1, k) = strDate |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print on worksheet
Add .Value
Worksheets("Settings").Range("a1").Offset(1, k).Value = strDate see if that works Mike F "Arne Hegefors" wrote in message ... Hi! I have a simple problem. I want to print a certain value in on a worksheet in a loop. For each loop I want to print on one cell below the previous one. However there is something wrong with the line below, it does not write anything on the worksheet. pls help! Worksheets("Settings").Range("a1").Offset(1, k) = strDate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart doesn't print w/worksheet properly but will print by itself | Excel Discussion (Misc queries) | |||
| how do u print back2back print of different worksheet in exel. | Excel Worksheet Functions | |||
| print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions | |||
| Multiple print areas, one worksheet -need to print to PDF! | Excel Programming | |||
| Print Macro that will Print Entire worksheet except.... | Excel Programming | |||
Linear Mode
