Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
Hello everyone, I have a program that when you type a code and press a button
a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
See response in .misc.
-- HTH RP (remove nothere from the email address if mailing direct) "filo666" wrote in message ... Hello everyone, I have a program that when you type a code and press a button a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
in your macro have it do something like
Cells(rw,col+1).Value = Date -- Regards, Tom Ogilvy "filo666" wrote in message ... Hello everyone, I have a program that when you type a code and press a button a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
WHAT IS RW AND COL+1????
"Tom Ogilvy" wrote: in your macro have it do something like Cells(rw,col+1).Value = Date -- Regards, Tom Ogilvy "filo666" wrote in message ... Hello everyone, I have a program that when you type a code and press a button a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
rw is the row number and col is the column number. col + 1 indicates 1
column to the left. This is pseudo code to represent the concept. You haven't asked a specific question. If you wanted the date to the right of the activecell, it would be activecell.offset(0,1).Value = Date for example. -- Regards, Tom Ogilvy "filo666" wrote in message ... WHAT IS RW AND COL+1???? "Tom Ogilvy" wrote: in your macro have it do something like Cells(rw,col+1).Value = Date -- Regards, Tom Ogilvy "filo666" wrote in message ... Hello everyone, I have a program that when you type a code and press a button a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult thing to do¡¡¡
tks, I want to learn more VB functions, where could I learn about this????
"Tom Ogilvy" wrote: rw is the row number and col is the column number. col + 1 indicates 1 column to the left. This is pseudo code to represent the concept. You haven't asked a specific question. If you wanted the date to the right of the activecell, it would be activecell.offset(0,1).Value = Date for example. -- Regards, Tom Ogilvy "filo666" wrote in message ... WHAT IS RW AND COL+1???? "Tom Ogilvy" wrote: in your macro have it do something like Cells(rw,col+1).Value = Date -- Regards, Tom Ogilvy "filo666" wrote in message ... Hello everyone, I have a program that when you type a code and press a button a macro automatically discount one of the code from stock, my problem is that my boss want that wen you execute the macro in one cell appears the substraction date of the code. The problem is that if I use the now() function the following day the registration date change, and also if I make a macro that copy the column and paste the column as values, the program doesn't going to work when I type another code, if I make a macro that retype the formulas in the cells, it will errease all the last cells. PLEASE HELP I'm having trouble in my job ans I really need to do something with this. Gratefully |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, too difficult for me. | Excel Worksheet Functions | |||
Too difficult for me, please help. | Excel Worksheet Functions | |||
Difficult but do-able? | Excel Discussion (Misc queries) | |||
A difficult thing to do¡¡¡¡¡¡ | Excel Discussion (Misc queries) | |||
A difficult thing to do¡¡¡¡¡¡¡ | Excel Programming |