Is there some way to capture the value of the last non-blank cell in a range? Thanks
H Harvey Waxman Sep 20, 2003 #1 Is there some way to capture the value of the last non-blank cell in a range? Thanks
B Bernard Rey Sep 20, 2003 #2 Harvey Waxman wrote : Is there some way to capture the value of the last non-blank cell in a range? Click to expand... I guess it's within a Macro you're trying to get this. Her's my suuggestion: Range("A1") = Range("A65536").End(xlUp).Value This will browse the col A, starting from the very bottom, up to the first non-blank cell and put it's value in Cell A1.
Harvey Waxman wrote : Is there some way to capture the value of the last non-blank cell in a range? Click to expand... I guess it's within a Macro you're trying to get this. Her's my suuggestion: Range("A1") = Range("A65536").End(xlUp).Value This will browse the col A, starting from the very bottom, up to the first non-blank cell and put it's value in Cell A1.
H Harvey Waxman Sep 20, 2003 #3 Harvey Waxman wrote : I guess it's within a Macro you're trying to get this. Her's my suuggestion: Range("A1") = Range("A65536").End(xlUp).Value This will browse the col A, starting from the very bottom, up to the first non-blank cell and put it's value in Cell A1. Click to expand... Merci very much
Harvey Waxman wrote : I guess it's within a Macro you're trying to get this. Her's my suuggestion: Range("A1") = Range("A65536").End(xlUp).Value This will browse the col A, starting from the very bottom, up to the first non-blank cell and put it's value in Cell A1. Click to expand... Merci very much
