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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define Variable Name using VBA
set c = Cells.Find(What:="original amou", _
LookIn:=xlFormulas, LookAt:=xlPart) set c = Cells.Find(What:="original amou", After:=c, _ LookIn:=xlFormulas, LookAt:=xlPart) c.Offset(0, 1).Select "GTReferee" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define Variable Name using VBA
Joel, the first part works great finding the cell. Now I be able to do a Name/Define for that cell. "Joel" wrote: set c = Cells.Find(What:="original amou", _ LookIn:=xlFormulas, LookAt:=xlPart) set c = Cells.Find(What:="original amou", After:=c, _ LookIn:=xlFormulas, LookAt:=xlPart) c.Offset(0, 1).Select "GTReferee" wrote: 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 |
Reply |
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 |