Hi all
I have a table which is regularly sourced via "get data" from another xl file
row A will have "0" (zero) occur at irregular intervals
When "O" occurs I would like to automate a cell validation condition (="") on the next 5 cells in that same row (B,C,D,E,F)
I am stumped after
sub validatecells()
Application.Goto Reference:="Query_from_Excel_Files_1"
(pathetic isn't it)
any advice?
tia kd
I have a table which is regularly sourced via "get data" from another xl file
row A will have "0" (zero) occur at irregular intervals
When "O" occurs I would like to automate a cell validation condition (="") on the next 5 cells in that same row (B,C,D,E,F)
I am stumped after
sub validatecells()
Application.Goto Reference:="Query_from_Excel_Files_1"
(pathetic isn't it)
any advice?
tia kd