Search results

thanks. i wasnt so far. i just dont know to write the last formula with the "rc" operator. and the truth that i am still dont get the idea with this. its work perfect as i wish. thank you very much.

hi there, i wrote a realy simple macro that multiply cells and lives a formula inside the cell. same row , different column. the life was too easy. but the real problem is that i need the macro to be dinamic. my meaning is: the macro needs to identify the number of the column by the column name...

hi, i have an error message in excell when i am trying to run a macro: "Excel ran out of resources.... how can i solve it. i have macros with loops on 5'000 lines. any Suggestions??

hi, i have a pivot table that i want to ove into p.p. the problem is every column has a filter sign. how can i move the filter sign without lose the tital???

lohith, your idea work very good. thanks to everybody...

hi narayank the code you suggest make an error "type mismatch" on this line: x = Array(30, 36, 45, 50, 54, 63, 69, 91, 94, 133)

my code runs with vlookup see below: Sub expances_sheet2() Dim cell As Range Dim i As Integer ' Workbooks(".xlsx").Sheets("").Activate Workbooks(".xlsm").Sheets("").Activate On Error Resume Next For i = 6 To 138 If Not i = 30 Then If Not i = 36 Then If Not i...

hi, i have code with 'for' loop 6-138 i want the loop to ignore 10 numbers. i know that i can write if not statement to ignore one number. how can i ignore 10 numbers in one if statement? i attach part of the code to explain my question. the code runs on column with loop on the cells Sub...

hi, i upload the workbooks to rapidshare. https://www.rapidshare.com/#myrs_filemanager/file/0 notice that the two workbooksare empty i just want the macro to work. notce in my code that from workbook2 i search for if workbook1 is open. thanks again for your patience. asaf

yes i saved the files. where can i upload file?

hi probably i am doing something wrong the function is not working as well. i tried the function and procedure below like marc suggessted: Function IsOpen(Name$) As Boolean On Error Resume Next IsOpen = IsObject(Workbooks("workbook1 .xlsm")) End Function Sub find1() If IsOpen("workbook1...

hi again i tried this code again and its not finding the workbook name. for instance i created 2 workbooks: workbook1 and workbook2. then i try thi code below: Sub IsWorkbookOpen1() Dim wbName As String Dim wb As Workbook wbName = "worksheet1.xlsm" For Each wb In Workbooks...

question to vijay.vizzu its not working. can you check it. the fot each loop seems to be very simple but not work. thanks again...:)

hi, i have macro to open a workbook. i want to add single statement before to check if the workbook is already open please help.

THANKS' I MADE IT BY MY SELF.

that works but i want to put this inside cells. instead of msgbox i need to put the names in a cell

hi there i have a little problem i cant solve' i want to write a code that tells me what workbooks is active all the time. i succeed to write a code that tells me how many open but i cant get the file name. please help' asaf

hi, i have a simple problem with excell chart.i have 2 charts' one for the sales and one for the budget. inside all chart i divided the parts into x,y,z. i need to merge this two chrts into one. it should look like every month i have the sales and the budget and must have divided inside to...

here is the example: catalogic number abc1234 abs12345 abc123 abc12345678

hi, I have a little problem, I have column with cataloged numbers like below: number + letters the problem is that the number in the cells can be 4 or 8 or 3... I cant use "right" formula. I need a formula that recognized how to look only for the numbers enclosed herewith file with...

hi, i wrote a simple code that suppose to run in main range, and inside this range i need the code to run column by culomn. the range is between column b to i, and i need to run first on column b after that to run on column c and ect... in every column thecode must manipulate the cells...

how can i set a range to compare in diffrent sheet?

its working very good, but i barely understand it. can you xplain it step by step?

i try it. its not working, and i understand why. the last rows its the problem. after the second "end if" there is "next x" that run the loop again until he finish the x range. after finishing x range the macro goes to cell range. well, this code is not good and not working. someone can...

hi colin. i want that cell a1 will compare to c1, and a2 compare to c2. the reason why i'm not doing it in conditional formating is the fact that i need to build this code on 30 different ranges scatered on a file with 6 sheets. any way' now the code isnt working no matter what numbers i put...