Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I run this bit of code to find the address of the the last cell in column K.
Sub test() Dim x As Range Worksheets("NCSA_ISS_ITEM_BOM").Activate Set x = Cells(Rows.Count, "K").End(xlDown) MsgBox x.Address End Sub I would like to save the resulting row address as a variable to run as part of another set of code. How would I go about doing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save As Code | Excel Programming | |||
Save As code | Excel Programming | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
Placing a code before Save & Save As | Excel Programming | |||
save without code | Excel Programming |