Search results

if I remove the Do while loop, then error comes at AppActive ie line. Tried even removing that line, but error comes at ie.quit line. Please also suggest if there is any easy method to import pdf to excel. (text only )

Hello, I am trying to import some PDF files to excel using IE (open it in IE and copy-paste to excel ). My code is working for some pdf files. but for some it returns following error : The remote server machine does not exist or is unavailable Searched many forums to resolve this, but all leads...

Hello Masters, In my excel workbook, I have defined many named ranges. Most of these named ranges are dynamic in nature based on user inputs. Is there any way to find and use 'usedrange' of a named range in a form? I will explain: range("A1:A10") named as say 'index' The range will get...

Wow.... This fulfills my quest. Thanks a lot Somendra.... :awesome::awesome::awesome: I knew, that me like people who have very less coding knowledge also can find solution here. Great going guys.... :awesome::awesome::awesome:

Thanks SN152. But, i was looking for something else. In my original sheet, I can get the address of the cell from which the data should be filled. Dim rCount As Long With Sheets(3).Range("a1:z1") Set r = .Find(combo_cat.Text, LookIn:=xlValues) temp = r.Address but I am not sure...

Hi, I am trying make a excel form with two drop down selections (category, sub category) to get some data from user. Drop down - sub category is based on category selection. I need user to enter some amount in the space provided. When 'OK' is clicked i want the sub category and rate to be...

Thanks a lot Hui and Luke.

Hi, I have created a sample excel sheet (and attached) to explain my criteria. In my case, there are test cases with some sub tests and test cases result will automatically populate based on the sub test result. I would like to add expand / collapse options for the test cases with + / - signs...

Thanks Hui. Wonderful.

Hui, In my code below (in sheet1), I am trying to call/run a macro based on a cell value change. The below code is working for me if the source cell (B7) and target cells/range in macro (reset and playback) are in same sheet. But my workbook is bit large and have several sheets. So i want to...

I need to do 'Text to column' to that particular column. Thanks Smallman.

Got a solution. I modified the code as Dim address as Range With Worksheets(1).Range("a1:aa1") Set c = .Find("text to find", lookin:=xlValues) If Not c Is Nothing Then address = c.Address c.EntireColumn.Select Else MsgBox "Nothing to find" End If End With Share if there is a better way.. Thanks

Thanks Debraj

Hi, Below is my situation: Want to look for a word (text) and once find, i need to select the column. When searched on net, i got find function help. Code is below: With Worksheets(1).Range("a1:aa1") Set c = .Find("text to find", lookin:=xlValues) If Not c Is Nothing Then address = c.Address...

Hi, I have a macro that search for a string and copy-paste the entire row to new place. Need help for a modifications. ?? Need to set the macro to start pasting the result from a particular cell instead of last row. Macro i want to modify: Private Sub Click() Dim strLastRow As String Dim...

Thanks Luke

Thanks Luke. A small concerns... . Need to run this on background starting from file open and need to run this only if a cell have a value. with your suggested macro, i have to run macro from developer options and on executing the macro am seeing the range filled like this...

Hi all, looking to add hyperlink to a range of cell. My requirement/situation is below: 1. each cell will fill with numbers (5-8 digits) 2. need to add hyperlink to same cell 3. the link address is as follows: first part will be same for all cell ( eg: www.mysite.com/page/) + the cell value. 4...

I got one solution. http://stackoverflow.com/questions/11901686/excel-lock-range-of-cells-based-on-values/11902463#11902463 Thanks.

Is there any option to protect a cell in excel 2012 based on another cell value without using any macro ? Thanks in advance.

Hi all, In my office there are a lot of projects running almost in parallel. I would like to plot their status date by date on a graph so that the one who view should get , project length project completion status, I have an image got from a webpage, looks like the the graph what i am...

Hi, I have a workbook in which i need to disable copy/paste. I got some macro codes to do that. but if i saved the workbook in .xlsx or .xls format, that wont work (expected). So, is there any other way to prevent copy/paste ? -Vijesh

Thanks Hui... it works...

Hi, Small confusion on conditional formatting. can i do conditional formatting on mutilple cells (not necessary to be in same row/col) in single shot ? i can explain my scenario: Am using Excel 2010. I selected B2,D3,E4 cells for conditonal formating. Then selected 'Conditonal...

Thanks Hui. Your guidence solved my problem.