xlnone

hi, i am getting problem when i call userform. it seems i am missing something and getting object . when i call userform it appears and when i try to submit that i get error,is that some old version and new version issue or something else how to solve this error. i am now using Excel-2010. i...

Hi All, So i have run into a problem that I cant seem to solve. Here is the code in question: Dim YY As Long Dim ZZ As Long YY = 0 ZZ = 0 For j = 2 To MaxRow If InStr(1, ActiveSheet.Cells(j, 2), "End:") <> 0 And ActiveSheet.Cells(j, 32) < 0 Then ActiveSheet.Cells(j...

I am new to VBA, but I have been able to edit my recording enough to get what I want to this point. Here is what I have so far: ActiveCell.Offset(-12, 0).Select Range(ActiveCell, ActiveCell.Offset(0, 16)).Select Selection.Copy ActiveCell.Offset(12, 0).Select ActiveSheet.Paste...

hi, this is my current code: ' ' importdata Macro ''workbooks("lap_lookup.xlsm").sheets("info").unProtect Workbooks.Open Filename:="C:\123\123_data.xlsx" Range("A2:H3007").Select Selection.Copy Windows("123_lookup.xlsm").Activate Range("A2").Select ActiveSheet.Paste...

Hello everyone! Since a few days I am working on a macro, which creates a pivot table. My goal is,that links from a report get also in pivot table clickable. I have already achieve that :) -> I edit the newly created sheet (pivot in new sheet) in VBA. To wit by the text below: Private Sub...

In the 'red'code below , if the user chooses N, I need it to go to the 'green' code bit at the bottom just before the 'exit' so the cursor ends up in cell A2 & a msgbox dispalys to prompt the user with a message of advise. It works fine if Y is chosen? Sub importdata() ' ' importdata Macro...