Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
Hello I posted this same question a while ago but I dont think it actually
got posted. I have the following code: Sheets("Output").Range("A1").End(xlDown) = " Final" and it generates what I want except that I need it in the following row. I tried: Sheets("Output").Range("A1").End(xlDown-1) = " Final" but didnt work, how do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
try:
Sheets("Sheet1").Range("A1").End(xlDown).Offset(-1, 0) = " Final" "M&M" wrote: Hello I posted this same question a while ago but I dont think it actually got posted. I have the following code: Sheets("Output").Range("A1").End(xlDown) = " Final" and it generates what I want except that I need it in the following row. I tried: Sheets("Output").Range("A1").End(xlDown-1) = " Final" but didnt work, how do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
YEp it Works thanks!!
"Toppers" wrote: try: Sheets("Sheet1").Range("A1").End(xlDown).Offset(-1, 0) = " Final" "M&M" wrote: Hello I posted this same question a while ago but I dont think it actually got posted. I have the following code: Sheets("Output").Range("A1").End(xlDown) = " Final" and it generates what I want except that I need it in the following row. I tried: Sheets("Output").Range("A1").End(xlDown-1) = " Final" but didnt work, how do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |