Dave evans
06-01-2018, 02:23 AM
hi all
just joined and have a question i have googled to solve this problem i have to no avail so help here is available i hope
ok then i have created a database that works fine but i need to change the direction it saves the entered values
at the moment it enters horizontal data and i want to use it to enter vertically when submitted
is there any code that will allow me to do this below is the current code being used
'find first empty row in database
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
thanks in advance for your help
just joined and have a question i have googled to solve this problem i have to no avail so help here is available i hope
ok then i have created a database that works fine but i need to change the direction it saves the entered values
at the moment it enters horizontal data and i want to use it to enter vertically when submitted
is there any code that will allow me to do this below is the current code being used
'find first empty row in database
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
thanks in advance for your help