hi people,
i am writing a macro in which i want to search for particular number starting with '3' in a column (say for instance C). I know, using 'cell.find' we can search it. but i don't know how to use it and more over i want to stop searching once it reaches a blank cell.
thanks in advance...
Hi everybody,
i have a question regarding chart creation in excel. i have the following code to create a chart and resize the plot area. what my problem is, while creating the chart we can see how it is being resized. i don't want users to see what it is doin. as soon as it is done with the...
thanks Mike. but i tried it, still its not working. it gives this error 'object dosent' support this property or method' it gave error at Workbooks("temp.xls").Sheet1.[E10].FormulaR1C1 = "=RC[-3]-5". i rightclicked on it and clicked the definition then it gave a message...
Hi people,
i am writing a simple macro in excel but i don't know what i am doin wrong.
here is the thing i wanted to do,
open a file (temp.xls) and manipluate some cell data. i created a button in a file and inputed following code
Private Sub CBopen_Click()
Workbooks.Open...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.