Search results for query: *

Hi, does anybody know how to execute a button without clicking it? Application.Run"ExcelName.xls!Buttonname" doesn't work Thanks, vix

Hi Chris, A follow up question, How can I do this for the code to know upto which row it will go? For example, Data size is variable. How can I make the autofill upto only the cell wherein there is the data on the cell next to it? A(N) size is unknown... Thanks, vix

Thanks! :) Yep this is perfect!

Hello, Can anybody help me do autofill of column upto last entry adjacent to it? 1 entry1 2 entry2 3 entry3 : : : : N entryN Where N is not known and can be any number and the entries can autofill upto this N column. Thanks, vix

I just added C[-3]... But I think C without column number is correct since I just recorded the macro and looked at the code for this... L is actually the Sheet on NameX... Sub Iterate() Dim c As Range Windows("NameX.xls").Activate For Each c In [tbl]...

still no luck... :(

Oooppsss... you're right... Thanks very much! :)

Hello Again, Thanks Skip... I dont know why but I am getting Application defined or Object defined Error on the "ActiveCell.FormulaR1C1.... " line. I actually have 2 files. Name and NameX. My table is in NameX and I want to apply the formula in the Name file... Sub Iterate() Dim c...

Hi Geof, How do I assign a Range into tbl. It is not as easy as Range("A2:A60")=tbl Sorry if I keep bugging you on this... Thanks, vix

Yes! Exactly! Thank You :) Regards, vix

Hi Geoff, Actually, I only have 1 target cell. And I have a table as the source of my input to that one cell... Can you explain the algorithm you gave me? thanks. Ex. I want to loop through these cell values.... Cell Input1 Cell Input2 Cell Input3 And store it one by one to: Cell Target...

Hi Geoff, Actually, the cells in that 1 column serves as an input parameter to another marco. After transferring one value of that column, the macro is performed. So that is why I need to loop through the cells one at a time. match the value of one cell, do the macro and then move to the next...

Hi Mike :) Cell.value actually refers to the values of 1 column as I loop through the column... I would still need th for loop for looping through the values in that column right? Thanks, vix

Thanks ETID. I just want to know the syntax/method to use in for loop. For Each Cell in Selection ActiveCell.FormulaR1C1 = _ "=INDEX('[Name.xls]L'!R[-11]C[-3]:R[50]C,MATCH('[Name.xls]L'! Cell.Value ,'[Name.xls]L'!R[-11]C[-3]:R[50]C[-3],0),3)" Next I cannot use Cell.Value...

Hi, For example I want to put this formula in a loop. ActiveCell.FormulaR1C1 = _ "=INDEX('[Name.xls]L'!R[-11]C[-3]:R[50]C,MATCH('[Name.xls]L'! CELL_LOOP ,'[Name.xls]L'!R[-11]C[-3]:R[50]C[-3],0),3)" How can I make CELL_LOOP into a column array? How should I construct the...