Recent content by cboz

thanks that worked. i had tried String earlier but i still had the quotes.

in excel 2007 i want to be able to enter a single cell address then execute some code. here is what i have tried. Dim MyCell As Range MyCell = InputBox("Enter Beginning Cell i.e. A1") Range("MyCell").Select 'this is where the error occurs

Thanks. You just saved me hours of trial and error.

In Excel, I have a macro that formats all of my PageSetup stuff. I would like for the macro to prompt me to input a title in the .CenterHeader. Is this possible? Here is the code for the macro as it is now. Sub PageSetupLandscape() With ActiveSheet.PageSetup .PrintTitleRows =...

Thanks.

I want to replace MyName with the tab name of the active sheet in the following code. How is this done? ActiveWorkbook.SaveAs "G:\Procurement\CXB\07 Vendor forecasts\" & MyName & Format(Date + 3, "yymmdd") & ".xls

that was the first thing i tried but when the user tried to open the file it did not give the option to open as read only. i must have done something else wrong because it is working now. thanks for your prompt reply.

how do i make a file read only for everyone else but me? Here is the code i used. ActiveWorkbook.SaveAs "G:\Common\A A Never Out Reviews\" & Format(Date, "mmddyy") & ".xls", FileFormat:= _ xlExcel9795, Password:="", WriteResPassword:="", ReadOnlyRecommended:=True if i put in a password...

I have a hyperlink field in a table called Photo I want the user to be able to fill in this field on form by browsing for the file that holds the picture. The user could type in the path but that is fraught with opportunities for typos, so I would like for the path to automatically populate the...

Thanks that worked. I don't understand how it works. Why do you need to put the ">" in quotes and add the "&". Sorry to have asked in the wrong forum. I am usually working on macos when I get stuck and have a question.

I want to count the number of times the value in cells T251 through AE251 is grater than the value in cell L251*2. The formula below returns Zero when I want it to return 1. The values in T251: AE251 are as follows. 2 32 10 6 8 5 12 9 5 10 7 3 L251*2 = 30 or 15 x 2 = 30 The...

Other than the column heading "Sales_Order", who's location could change from one day to the next, then no. This worksheet is the results of a pivot table. The sheet the pivot table is based on varies as to what is in it each day. This is why the Sales_order column isn't always in column 8.

I have the folowing code in a macro: Range("M2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,MRPDet,8,0)" The problem is that sometimes the data in not in column 8. It could be in columns 6, 7 or 8. How do I compensate? The named range for the column I want to use is called Sales_Order.

Excellent! Thank you so much.

i am still getting the compile eroor "Object requrired". my code is now as follows: Dim myDte As Date Set myDte = Date + 100