| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New issue with "With" statement
Thanks Jim for pointing that out. Makes sense!
-- Robert "Jim Cone" wrote: I assume Bob is probably with a paying customer, so... If you are in Column A there is no room to offset 3 columns to the left... To use F.Offset(0, -3) you must be in column D or higher. Also, .Range(F.Address) is a perfectly acceptable use -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "robs3131" wrote in message Hi Bob, I tried this both ways you listed below and I'm getting "Run-Time error '1004'" both ways...any thoughts? -- Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have a macro simply issue the "find" command or "control f: | Excel Programming | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
| vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming | |||
Hybrid Mode
