Search results

Well, I've tried, but I can't seem to get a single column. I can get a SQL query into a recordset variable, but I have trouble grabbing particular columns from that recordset, and then looping through the cells of that column. I'm including all the code below, with nothing left out. The lines...

thanks again for the reply. My VB editor doesn't recognize "rsCurr" as anything (that is, it doesn't seem to be a reserved word, etc). How do I assign a column to rsCurr in the first place? thanks again, sorry for the newbie questions. VBA is a very occassional tool for me, so I don't know a...

thanks for the reply. so, while i understand the algorithim, it's the getting of the column that is eluding me. How would I get a the column of the selected cell into a recordset, for example? here's some example code i pulled from elsewhere: Sub fillValues() strPrevValue = "" Do...

Hi Folks, I'm trying to write a script that will fill empty cells in the selected column with the value of the first non-empty cell above (such code has been posted here before). However, I can't figure out how to get the selected cell into a recordset object in the first place (from which I...