Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-04-2021, 11:58 AM

trevorc

Windows 7 32bit Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 PM.