| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a string to reference an address
I want to use my strCell to reference an address, such as "A1" - how would I
copy this cell? strCell.Copy does not work - I'm assuming it is because I am using a string and excel can't read my mind :) If rngCodeFound Is Nothing Then MsgBox "No FTO" 'Code is found Else strCell = rngCodeFound.Address strCell = Right(strCell, 2) strCell = ("A" + strCell) ' copy the cell that strCell variable references ' paste the copied cell to a new wks End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I extract a string from an IP address in Excel? | Excel Discussion (Misc queries) | |||
| How do I extract a string from an IP address in Excel? | Excel Discussion (Misc queries) | |||
| Convert text string to IP address | Excel Worksheet Functions | |||
| How do I manipulate a string to collect the address from it? | Excel Discussion (Misc queries) | |||
| Extracting out of a emai address string | Excel Discussion (Misc queries) | |||
Threaded Mode
