var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: change row after finding cell
ok so in my spreadsheet I and looking for part numbers in one of two colomns so I used the find function
only now that I have found my cell say 'B55' I need to start changing all kinds of things in the entire row. 'A55 - M55' using my nifty userforms I made.
Only I donno how to go from found the cell to let it know what row I am in. Is there a way to say like
row= Active Cell row ???
cuz then I could go F,row change to blue
You were almost there
hmmmm more info
I thinks I am going to need a little more information about all that.
Ok lets say found my cell (c55) using that find thing and now it's active
I type irow=activecell.row
is irow a variable called out somewhere or is it already built in. I tried calling it out as a variant but it dont seem to be working right.
anyway my next bit of code is going to be
if MEtxtbox = 1 then
Activecell.formmulaR1C1 = "x"
only i need "E4" in terms of "irow"
so then i tried
but that don't work either
sorry guys that is
MEcheckbox = 1
What you need is
dim iRow as integer
Range("C" & iRow).Select
or more directly
Range("C" & ActiveCell.Row).Select
Note you do not have to SELECT the cell or row to format it etc. just refer to it ie
Range("C" & ActiveCell.Row).NumberFormat = "£#,#0.00"
or whatever format you want, if that helps
thanks a bunch. worked sweetly.
Just a note on this topic just as another perspective on it
If you set the range of the find to a variable you can just get the row of the find from that variable, the advantage of this is that if you can't find anything then you can handle this
Here is a quick example
Dim rngFind As Range
Set rngFind = Cells.Find(What:="Find This")
'check to see if anything found
If Not rngFind Is Nothing Then
'if so run this
Range("C" & rngFind.Row).NumberFormat = "£#,#0.00"
'or code if not found
MsgBox "Not Found"