JKB
09-09-2014, 06:22 AM
Hi out there!
I have a simple problem, that must have a simple solution but i couldnt find one!
Usually when i want to select a range relatively (with that i mean all the way down, if the cell contains something) i use the following method:
sht.Range("A1:F" & Range("A1").End(xlDown).Row).ClearContents if i wanted to clear the contents of cells from A1 to F (and then all the way down until there is an empty cell).
But i would like to replace this "F" now, since i want to be able to expand the width inside the program. How do i do this?
Put in another way: How do i choose ctrl+shift+down AND THEN ctrl+shift+right and select in vba-language?
I have a simple problem, that must have a simple solution but i couldnt find one!
Usually when i want to select a range relatively (with that i mean all the way down, if the cell contains something) i use the following method:
sht.Range("A1:F" & Range("A1").End(xlDown).Row).ClearContents if i wanted to clear the contents of cells from A1 to F (and then all the way down until there is an empty cell).
But i would like to replace this "F" now, since i want to be able to expand the width inside the program. How do i do this?
Put in another way: How do i choose ctrl+shift+down AND THEN ctrl+shift+right and select in vba-language?