integer

I'm wondering why my code sometimes works and sometimes doesn't (giving me a Runtime 1004 The extract range has a missing or illegal field name). I'm using .AdvancedFilter to remove duplicate names from a selected column so that each name is only counted a single time. I get the error message...

Good day. I would like to ask help regarding conditional setup. So I have a dates that will be filtered based on the condition and will copy paste it. My problem right now is if the condition dates are not available, it will copy all the information. So if the condition dates are not available...

Hello and thanks in advance for any assistance. I have a work sheet with two tabs named DATA PULL and LIST. The LIST tab contains a list of keywords (250 words) in column A. I need to search for those key words in columns P and Q on the DATA PULL tab and return any matches to column I(the data...

Hello, I got stuck on the following code that shows date selected from datepicker Private Sub select_label(msForm_C As MSForms.Control) '/* Capture the selected date */ Dim i As Integer, sel_date As Date i = Split(msForm_C.Name, "_")(1) - 1 sel_date = FirstCalSun(curMonth) + i...

I am trying to create a dynamic number of labels and textboxes with the following code and it sort of works. However, I want to use a variable to make sure that the labels and the textboxes don't go outside of the userform. I have tried a select case and if else statements but they offset the...

I have read that it is useful to define a variable taking on integer values as "Long". Yet most examples I see define such a variable as "Integer" which, of course, it is. Can you provide clarification or the thinking behind an integer being defined as "Long"? Thanks, Kerry

Hello Everyone, I have encounter a strange situation, the codes that i have below sometime runs without any error message, but sometime it gives me a Run-Time Error '91': Object variable or With block variable not set Can someone please help to explain why this happens and what can i do to...

Greetings, I have a macro that I would like to use to convert date values in columns of data. I would like to be able to set the column value to convert with the integer variable 'a'. The material inside the with statement is not functioning. I have two questions. 1)How do I set the output...

I'm new to VBA (and coding in general. I've been trying to copy a set of data (client data) from one sheet and pasting it in a specific row. And I want this to happen when the client number equals the client number on the first sheet. This is the code that I've written so far. Can someone help...

So I found this code that creates barcodes as an object, problem is the barcode that is created always ends up to the right side of the formula. I've tried to change the X and Y variables, but can't really find a way so that it always posts it below the cell not to the right side of the cell...

Dear Friends and Respected Seniors, i have this data in sheet2 starting from cells a1:b9 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> a 8 b 5 c 2 h 4 j 3 k 85 y 65 u 47 i 11 </tbody> I want to...

This script creates a lot of empty rows in the arrays. I understand why, but I don't know how to write the code so it won't, some pointers please. Sub GroundogDay() Dim i As Integer Dim Count As Integer Dim ArrDATE(1 To 33) As Variant Dim ArrROW(1 To 33) As Variant For i = 3 To 33...

Hello, I am looking to to generate a list of values in a worksheet based on if the cells are coloured in other worksheets. I've posted the code below. My thinking is that in the first worksheet, the first cell will check if C1R1 of another worksheet has a filled background or no fill. if filled...

Private Sub lstView_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim n As Integer, ac As Integer, i As Integer i = Me.lstView.ListIndex With lstView For ac = 1 To .ColumnCount .TextColumn = ac Me.Controls("Rw" & ac).Value = .Text Next ac...

Hi everybody, I'm still trying to wrap my head around the idea of 'early' and 'late' binding and I couldn't understand it. I've looked up on google but I don't know how to apply to my code. Basically, I started looking for solutions when I created a shared file but people using different...

Hi there, I'm new here and hope that any of you will be able to help me out. I have a form that has a set of values that is kind of fixed (the range A in the table below) and a range that is dynamic (the range B in the table below(not always in the same collumns)...