|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date
Still going with this, I have fixed most of my poor referencing but I'm stuck on this one.
How can I change the column reference 'S' to a named range, its part of a table. I'd like to change this as if i add columns to the left, it throws off the references in other VBA code. Sheets("Customers").Range("S" & ActiveCell.Row) = Date |
#2
|
|||
|
|||
Does the column have a title you can search for? Its much easier to give an opinion with an example workbook
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way? | trevorc | Excel Programming | 2 | 04-30-2021 05:05 AM |
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range. | Syed Shabbir | Excel Programming | 1 | 09-27-2020 09:35 AM |
The "group or ungroup text range" control in the developer tab breaks my document up into many pages | damiansiniakowicz | Word | 8 | 05-10-2018 12:30 PM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
Making cross-reference say "Fig." instead of "Figure" | dgalb | Word | 17 | 11-09-2014 06:25 AM |