Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Quoting @PWT: "I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas."

Theree isn't such a shorcut - and you cannot set one, because the property "is blank or contains a formula currently returning the empty string (or just whitespace characters?)" is to complex to be supported by the queries running in the background if you pressed Ctrl+Arrow.

You would need to write a user Sub for the purpose and to asign it to your chosen shortcut.
If you can accept to have a similar functionality at hand only in specific cells (in the first frozen row e.g.), you may place a formula based on the HYPERLINK() function there. A subformula has to return the address of the target cell then, and HYPERLINK can provide the target for a jump by mouseclick (or Ctrl+mouseclick).

Quoting @PWT: "I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas."

Theree isn't such a shorcut - and you cannot set one, because the property "is blank or contains a formula currently returning the empty string (or just whitespace characters?)" is to too complex to be supported by the queries running in the background if you pressed Ctrl+Arrow.

You would need to write a user Sub for the purpose and to asign it to your chosen shortcut.
If you can accept to have a similar functionality at hand only in specific cells (in the first frozen row e.g.), you may place a formula based on the HYPERLINK() function there. A subformula has to return the address of the target cell then, and HYPERLINK can provide the target for a jump by mouseclick (or Ctrl+mouseclick). Ctrl+mouseclick).

Quoting @PWT: "I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas."

Theree isn't such a shorcut - and you cannot set one, because the property "is blank or contains a formula currently returning the empty string (or just whitespace characters?)" is too complex to be supported by the queries running in the background if you pressed Ctrl+Arrow.

You would need to write a user Sub for the purpose and to asign it to your chosen shortcut.
If you can accept to have a similar functionality at hand only in specific cells (in the first frozen row e.g.), you may place a formula based on the HYPERLINK() function there. A subformula has to return the address of the target cell then, and HYPERLINK can provide the target for a jump by mouseclick (or Ctrl+mouseclick).

Ctrl+mouseclick).

There was a related request in the German branch to which I supplied a working answer. If your German is sufficient, you may start with that proposal and adapt it to your needs.

Quoting @PWT: "I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas."

Theree isn't such a shorcut - and you cannot set one, because the property "is blank or contains a formula currently returning the empty string (or just whitespace characters?)" is too complex to be supported by the queries running in the background if you pressed Ctrl+Arrow.

You would need to write a user Sub for the purpose and to asign it to your chosen shortcut.
If you can accept to have a similar functionality at hand only in specific cells (in the first frozen row e.g.), you may place a formula based on the HYPERLINK() function there. A subformula has to return the address of the target cell then, and HYPERLINK can provide the target for a jump by mouseclick (or Ctrl+mouseclick).

There was a related request in the German branch to which I supplied a working answer. If your German is sufficient, you may start with that proposal and adapt it to your needs.

needs.

Edit1:
See also this attachment.
The range is fix there. You should replace the fix upper limit for row numbers by a variable one used on the third parameter position of an OFFSET() sub-expression.