goto

Can someone please help. I'm almost certain this code has worked fine in the past. I am a teacher and developed this tool to move students and their data from one class to another...... 'Moves a student from one set to another Sub MoveSet() DisableCalculation Application.ScreenUpdating =...

Hi all, i received a excel file, in that some column are locked, means not to enter specific column like C1 to E1 even cursor is out of these column c1 to e1. when you try to cursor goes to c1 then it will goto directly f1. can anybody tell me how is this?

Hi, I am trying to export data from an xlsm to a new xls. But the problem is that it only copies the first row and I need a table to be copied. My macro is this one: Sub ExportarTXT() Worksheets("Import").Activate If Sheets("Import").Activate Then Range("A1").Select If...

Hi! I'm just learning about excel macros and need one that will do something along the following (end result being goto cell row 25, column D in this example: 1) Cell a1 = 25 (or any # that's provided by the user in this cell) 2) Goto row value in a1, column D Next, I'd like a slightly...

Hello everyone, Not able to put value ZP05 and amount from excel sheet below is the code session.findById("wnd[0]/usr/tabsTAXI_TABSTRIP_HEAD/tabpT\07/ssubSUBSCREEN_BODY:SAPLV69A:6201/tblSAPLV69ATCTRL_KONDITIONEN").verticalScrollbar.Position = 0 jcount = 0 porgvalue = "" nn = 1 For k = 0 To...

Hi All, I have a VBA code i am using to password protect a document with multiple (50+) input worksheets and sensitive formulas The code i have (found online) input as a module is as below however i also need the users to be able to use autofilter where i have a filter bar included and...

Hello, I have a bunch of code as seen below that will count the number of files in a folder and subfolder based on the text found in A16. It will then paste the counters in a line on a main workbook. This works fine for smaller numbers of files but upon selecting a folder with a few hundred...

Hi, Is it possible to use multiple On Error Goto statement in single vba code? Actually in my code i want to use it twice. One on to to handle any error and one in between when giving command to delete all files on desktop. If any file is there on desktop it's working fine but when no file is...

Is it good practice to always follow an on error with a resume? For example, method 1: Sub Start() On Error GoTo Errhandler a = 0 b = 10 / a On Error GoTo 0 ' do something Terminate: On Error GoTo 0 Exit Sub Errhandler: Msgbox "Div by 0" Resume Terminate End Sub...

Hi Wizzards! I have a problem not being able to trigger my error handler after the code is trying to set an "empty list" for combobox rowsource. In a nutshell my code is trying to set the rowsource for a combobox, depending on a value in another combobox's value. I have tried to put "On Error...

I have a workbook that has several sheets. In sheet PorS_LFT3 I have a cell that says "See Sheet SW_LFT3 regarding translation at Stripe [C]" In this sheet SW_LFT3 is a row that contains the text "Stripe [C]". I am continually adding new content to the sheet SW_LFT3 which when the data sort is...

Good morning! I have a macro that functions as it should but is slow. The macro strips out all of the report and page headers from the text file dumped from the AS400 and organizes the sheet in the desired manner. I realize that part of the reason it's slow is the size of the worksheet it's...

Hello All, I have a simple request, if that someone could kindly please write a vba code. I have a single scroll bar (ActiveX control) that is connected to H25 cell; to which it goes up increment levels by one with every mouse click, starting from 1 – 194. What I like to achieve at some...

Hello I've had a requirement with a piece of work recently which involved me trying to use error handing within an if block containing several 'elseif' sections and an 'else' section. I couldn't get the error handler to behave as expected, as it kept jumping prematurely to the 'end if' line...

When I step through this sub, all of a sudden now it is triggering the Selection Change Sub I just made. This code was working fine. Now its not working and when I try to debug I see it jumping over to the Selection_Change Sub. Anybody know why it keeps jumping over to that Sub? Headscratcher...

Dear Gents, I have data like following table, and write codes to try get weekly data from daily (because of the format, I can't use pivot table in this case) I'm not sure how to determine how many monthweek in a month. Would you please help me figure out how to fix this out? (D =0 to 4 means...

Hi Guys, Can anyone tell me how i can adapt this code. Basically I use an input box and need a value of 0 or 1. If a different value is entered I want to goto the beginning so they have to enter 1 or 0. I am not sure how to write this code If x <> 0 Or <> 1 Then To test if the value is...

Hi Guys, I am inexperienced in VBA. I have written the following code. The program runs once if the Name is not found but returns error 91 If I retry rather than going to Namecorrection Label. I wonder why? Thanks in Advance Yasir Dim Name as String RetryAgain: Name = Inputbox("Type in...

This code works but once I trying updating a cell the code stops working. here is the code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Call Macro1(Target) Call Macro2(Target) Call Macro3(Target) Call Macro4(Target) Call Macro5(Target) End Sub Sub Macro1(ByVal Target...

Hi, I have a long code below that lists links to all files in a folder and then skips through all the links in the list and opens them so long as they are an xls file and have a sheet called 'QUOTES'. When open, it then copies and pastes some data into the main workbook. The problem is that it...