rowno

I found this code which works very well for my use. As my filtered list data set includes an unknown number of "Y" i need to include a variable to relplace the fixed +5 in the code below. Any assistance appreciated. Sub SetPrint() Set rowNo = Range("A:A").Find("Y", LookIn:=xlValues...

Hi All, I am trying to write code to cycle through rows in an excel spreadsheet and delete the row if the end column is less than 1. The code does delete the rows correctly however as it is a For x = y to z means that when a row is deleted the z does not reduce. I tried to fixed this by...

Hi I have been using a large EXCEL sheet with a lot of VBA. But suddenly a line does not work.. (It has been working for a long time). I get Run-time error '1004': Markeringen er for stor. (The marked area is to big) It works but only to 4000 rows, if there more i fails. I have the same...

Hello, i am a new user. From Portugal (sorry mistakes). I have a Userform with a Textbox and a button. Textbox to input the item and search button to find. I want: To search for an item in Column "C" of Sheet1 (input on textbox), It will find more than 5 when i click the search button. I need...

Have a variable defined: rowno I now want to colour yellow the cells from column A to H in row: (the row number calcated as rowno variable) Thanks

Hi I have excel files which contains Test Pair File and Live data file i want to update from Live data sheet to Test pair files every 5min time frame for ICICI & AXIS, NBCC & IRB as well as 15 min time frame for CIPLA & AUROPHARMA , BPCL & HPCL and also FROM "D" TO "P" columns are with...

Hi! I 'wrote' a macro using key strokes. I created a table which is done via the code below: ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$M$75"), , xlYes).Name = _ "Table1" My issue is I don't want the Range to always be the Range as defined here. I will be using worksheets...