| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How a macro auto-determine unspecified range
Hi, I have some data in column a & b, but the nos of input is no specified; in column c a formula a*b is made. Can anyone advise me ho a macro to copy the formula to the range in column C that just match al data in column a&b? Thank you -- eric ----------------------------------------------------------------------- eric c's Profile: http://www.excelforum.com/member.php...fo&userid=1573 View this thread: http://www.excelforum.com/showthread.php?threadid=27254 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How a macro auto-determine unspecified range
How about a formula of
=IF(AND(A1<"",B1<"")A1*B1,"") -- HTH RP "eric c" wrote in message ... Hi, I have some data in column a & b, but the nos of input is not specified; in column c a formula a*b is made. Can anyone advise me how a macro to copy the formula to the range in column C that just match all data in column a&b? Thank you. -- eric c ------------------------------------------------------------------------ eric c's Profile: http://www.excelforum.com/member.php...o&userid=15739 View this thread: http://www.excelforum.com/showthread...hreadid=272543 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unspecified Automation Error | Excel Discussion (Misc queries) | |||
| Unspecified Automation Error | Excel Discussion (Misc queries) | |||
| Unspecified Automation Error | Excel Discussion (Misc queries) | |||
| Copy cells with unspecified values to new sheet | Excel Programming | |||
| Auto Expend Range Using Macro | Excel Programming | |||
Linear Mode
