not working

Hi All, I am relatively new to macro and I was trying to use For loop in my code. It appears the loop is not running till end. My excel has some date columns but there are few columns where there is a gap in date between two consecutive columns. So what I was trying to do is to insert a column...

The following macro is working fine excel 2003...but not working in excel 2007... please help.... thanks in advance.... Public Sub ExcelGoogleSearch1() Dim searchWords As String With Sheets("Google Web") RowCount = 1 Do While .Range("A" & RowCount) <> "" searchWords = .Range("A" &...

I've assigned shortcuts keys to several macros in my personal workbook and in workbook specific macros, and suddenly none of them are working. Has anyone had this problem before?? I checked the security settings, they all look good. My computer just did an auto-update and I'm wondering if...

Hi, I am a beginner when it comes to macros and don't know much about the code (I just use the record function to create them). I have a worksheet with a lot of them and they all work fine, however I need to rename the spreadsheet and when I do this I start getting a Run-time error '9'. I...

Function Link(gccode) Link = (URL Begining) & VBAProject.Module1.Gcid(gccode) End Function Function Gcloglink(gccode) Gcloglink = Application.WorksheetFunction.Hyperlink(VBAProject.Module1.Link(gccode), "Log GC" & UCase(gccode)) End Function Here is the end part of my code. My code only has...

I have a macro for a new wt. form that I want to display a message if a range is below a negative value of another cell. But I can't seem to get it to work. I think the problem is in the part that I highlighted in red below. This is what I have: Private Sub Workbook_SheetChange(ByVal Sh As...

Hi, I am putting a formula/code into my excel page. It is working fine. But when I save it, close it, and reopen it, it does not work. Originally it was asking me to save it as a Macro-enable workbook, which I did. So it is already a Macro-enable booklet. Any explanations for this? How...

Hello, I am trying to Learn how to use line breaks and text wrapping to create a single cell that contains two lines of text. I found out that you use ALT+Enter, but it is not working. Any suggestions? I am using 2007. Kind regards, Trisha :)

When I use the WeekNum function =WeekNum(A2,1) to pull the week number for a row of cells with consecutive dates excel is saying that Tueday is the first day of each week. What the heck is gonig on and how do I fix this? Excel seems to be off by two days - the clock in my windows task bar seems...