Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define Variable Name using VBA
I have a worksheet that I copy infor into. The information varies from paste
to paste. When I define a cell with a name, it can change from paste to paste. I need to be able to find the required data "Original Amou" , then tab to the next cell and define the cell as RegisteredAmountOwing. Then I ahve a formula that captures the amount and creates a sentence such as "Amount owing = $43,623.62". Original Amou $43,623.62 Can someone help me with the code for defining the name each time I paste. i already have the following code to find the name and tab to the cell: Cells.Find(What:="original amou", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Cells.Find(What:="original amou", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ActiveCell.Offset(0, 1).Select -- GTReferee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Variable to Define Series | Charts and Charting in Excel | |||
How to take the worksheet name as a variable(Label/Define) in a fo | Excel Worksheet Functions | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Define drop-down results that are variable and dependent upon the. | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |