Search results

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...

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...

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...

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...

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...

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

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...

Hi, Greetings... I want to know, can i use function 'if' to color a cell ? if yes How? I have 3 condition(values) depending on which a cell need to be colored(3 different color). I tried conditional formating. But dont know how to use conditional formating to color a cell in 3 colors.

Hi, I am a newbee in excel. I made a excel sheet. To make it little attractive, i would like to insert a caption/message which is rolling ( marquee) How to insert a marquee in excel ? Am using excel 2010 All comments are appritiated. Best, Vijesh

hi, I have a excel( excel 2010) sheet in which many cells are protected. some of them is provided with hyperlinks. So when i protecting the sheet those hyperlinks become unusable. i dont want to unlock those cells to prevent modification of content. Is there any way to enale only hyperlink on...

Hi, I have a simple worksheet made to ease my day to day office job. To make it more attractive i am looking to insert some animated GIF to the sheet. Can anyone guide me to insert a animated GIF in excel 2007 ? Thanks in advance.