xname

Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets(sheet name is on left). I have written a macro. please advice the necessary changes <tbody> SheetNAme Option Strike Expiry NIkit c 11200 27-Jun-19 sandeep P 11300 27-Jun-19...

Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets on the left. I have written a macro. please advice the necessary changes <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Sheet1 Option Strike...

Hi I want to improve the code below so if a user entered a wrong name, then vba will give error message. I tried with IfError() as below but got error message. Thank you so much. Sub mylookup() Dim xname As String Dim xnumber As Integer xname = InputBox("name") xnumber =...

Hi, I saw this formula =VLOOKUP('1 Project Info & Instructions'!$G$25,'Excel Functions'!$D$4:$E$7,2,FALSE) in a sheet that was given to me and i am trying to figure out where is this "Excel Functions" sheet. I unhide all sheets , until the unhide sheet is grayed out. however I see it in VB...

I have a macro that applies protection to ranges in seven worksheets. It gives the ranges a title (required parameter) "Range1"..."Range7". The problem I have is that if I want to turn the protection off and then reapply it by running the macro again, the macro fails because "Range1"..."Range7"...

I am attempting to create a VBA macro which will save numerous excel files as CSV files without the text qualifiers before and after the text string. The below code will accomplish this, however, I can't get this to work without excel displaying the Save As prompt. How can I adjust the below...

So I was able to find VBA code to be able to search for a Worksheet within an open workbook. The issue is that there are going to be a lot of sheets, and remembering the exact name is going to be a challenge. Is there a way to add additional code that searches for a partial match and opens...

Hello, This is my very first post so pardon any faux pas, plus I am only a beginner at teaching myself VBA so please excuse any knowledge gaps. I've been trying to Frankenstein codes from too many forums and just can't get what I want to do done. My conundrum (and I will try to be as specific...