Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too tricky?
soz guys,
i tried both solutions but couldnt get them to work (and yes, i did spell format right). Bob, the macro ran but; 1. it just copied the last number and 2. it didnt paste it. but thats not what i wanted anyway :S Frank, I couldnt get urs to run. it had trouble with: ..cells(lastrow,"A").value = .cells(lastrow-1,"A").value+1 I'm no expert so i cant really tinker with them to make them work. I guess it will be something like: Selection.AutoFill Destination:=Range("A632:A633"), Type:=xlFillDefault but i need it not to be relative to specific cells. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too tricky?
Hi
please stay in the original thread :-) What problem did you have with my statement? -- Regards Frank Kabel Frankfurt, Germany ADRAIN wrote: soz guys, i tried both solutions but couldnt get them to work (and yes, i did spell format right). Bob, the macro ran but; 1. it just copied the last number and 2. it didnt paste it. but thats not what i wanted anyway :S Frank, I couldnt get urs to run. it had trouble with: .cells(lastrow,"A").value = .cells(lastrow-1,"A").value+1 I'm no expert so i cant really tinker with them to make them work. I guess it will be something like: Selection.AutoFill Destination:=Range("A632:A633"), Type:=xlFillDefault but i need it not to be relative to specific cells. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too tricky?
It says 'Run time error '13'. type mismatch'
then highlights: .Cells(lastrow, "A").Value = .Cells(lastrow - 1, "A").Value + 1 i have tried it with and without 'sub foo()' and 'End if' but i'm not really good enough to know what i'm doing -----Original Message----- Hi please stay in the original thread :-) What problem did you have with my statement? -- Regards Frank Kabel Frankfurt, Germany ADRAIN wrote: soz guys, i tried both solutions but couldnt get them to work (and yes, i did spell format right). Bob, the macro ran but; 1. it just copied the last number and 2. it didnt paste it. but thats not what i wanted anyway :S Frank, I couldnt get urs to run. it had trouble with: .cells(lastrow,"A").value = .cells(lastrow- 1,"A").value+1 I'm no expert so i cant really tinker with them to make them work. I guess it will be something like: Selection.AutoFill Destination:=Range("A632:A633"), Type:=xlFillDefault but i need it not to be relative to specific cells. Any ideas? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
This One Is Tricky Need Help !!!!! | Excel Discussion (Misc queries) | |||
A Tricky One...... | Excel Worksheet Functions | |||
This might be a little tricky...... | Excel Discussion (Misc queries) | |||
Is it just me or is this tricky? | Excel Discussion (Misc queries) | |||
Tricky maybe | Excel Worksheet Functions |