Chart Series name referencing cell address Excel 2010 VBA - Super User
Chart Series name referencing cell address Excel 2010 VBA. Why do you get your range like that? Is there a function to get the address of a cell which call a VBA function ? I used "Application. ActiveCell. Address", but found that this method is not a correct way. How do I get the source range or cell address of argument of function in VBA? I don't want my Excel Add-In to return an array instead I need a UDF to.
Get the address of ActiveCell ActiveCell Excel VBA / Excel /.
Get the address of ActiveCell. Moves the active cell up two rows RowOffset=-2 and four columns to the right ColumnOffset=4. For an example on getting the fill color used in a cell or range please see Excel VBA, Get Color Code. Your email address will not be published.