Search Results - VBForums

Search:

Type: Posts; User: scoobster

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: count non blank cells in data area within table object - result isn't what I expe

    fixed it using the following;


    Application.WorksheetFunction.CountA(Range(ListObjects("Header").DataBodyRange.Address))
  2. Re: count non blank cells in data area within table object - result isn't what I expe

    Sure. thanks for that.

    I just want to make sure I'm not missing any "table" related function / feature that gives the same result. I mean, most what is in the COUNTA is covered using table...
  3. [RESOLVED] count non blank cells in data area within table object - result isn't what I expected

    Hi

    I have a 2 row table object named 'Header' that fills range A6 to L7. Row 6 is the header and row 7 has the data. I want to count the number of non blank cells in row 7 but I only get the...
  4. Re: returning the worksheet code name for a sheet & a simple RANGE question

    Thanks for the feedback. I now understand what the code is doing so many thanks for that, vbfbryce. But it still leaves me working with the worksheet name and that can always be changed by a user. So...
  5. Re: replace part of text held in a merged cell

    I'm on a roll ... it works exactly as I want it to now. I used the following;
    [CODEON]With shtDest.range.usedrange[CODEOFF]
  6. Re: replace part of text held in a merged cell

    ah. solved it. Originally I was using a range set with just the columns (A:Z) and once I changed that to include row numbers then it works! No clue why.

    So I used this;
    With...
  7. replace part of text held in a merged cell

    Hi

    I have a merged cell and within that I have some text. So the text is something like;

    "the company name is {Company Name} and the contact is"

    I'm using the following code to replace part...
  8. Re: returning the worksheet code name for a sheet & a simple RANGE question

    hi there. sorry to replied delay but no chance to get online.

    Thanks for the code sample. As I read and understand the code, the issue I still have is shown in your code on the following code;
    ...
  9. Re: returning the worksheet code name for a sheet & a simple RANGE question

    Thanks.

    So I'm better off storing the sheet name and corresponding 'code name' in the listbox because then I know how to reference the sheet which the value selects from the listbox?
  10. Re: returning the worksheet code name for a sheet & a simple RANGE question

    sometimes I will copy from them to another sheet.

    Other times I might just want to read the range content.
  11. Re: returning the worksheet code name for a sheet & a simple RANGE question

    yep, I'd need to rename the content of the listbox. And I would refresh the listbox content on OPEN and whenever the worksheet changed. But it's the part after that I'm struggling with. How do I...
  12. Re: returning the worksheet code name for a sheet & a simple RANGE question

    If I have 3 worksheets in a workbook (Bob, Jon, Harry) and in VBA Editor I can the following;

    Sheet1(Bob)
    Sheet2(Jon)
    Sheet3(Harry)

    A user selects 'Jon' from the listbox and then I would like...
  13. Re: returning the worksheet code name for a sheet & a simple RANGE question

    I mean the sheet number that Excel automatically assigned when a sheet is created. That wont change if a user changes the order or the name of the sheet within Excel.

    I can see the sheet number...
  14. [RESOLVED] returning the worksheet code name for a sheet & a simple RANGE question

    Hello forum members,

    I have a listbox that contains a list of worksheets held on a workbook. The user will select a single value from the listbox and I will then copy the contents of that...
  15. Re: Selecting a directory and looping through all outlook PST stored in the directory

    Thanks for the tip. I'm not at all familar with coding for Outlook access. Any snippit of code available or do you know where I can find examples? I have trawled through a lot of Google results but...
  16. Selecting a directory and looping through all outlook PST stored in the directory

    Hi

    I need to pick a folder on my computer which is holding many PST files. Once the directory is selected then I would like to open each PST and carry out some processing. I already have the code...
  17. Re: [RESOLVED] Adding a border to a cell within a table range when values are missing

    Many thanks.
    I amended to use the 'borderaround' parameter to save a few links of code;
    .BorderAround ColorIndex:=3, Weight:=xlThin
  18. Re: Adding a border to a cell within a table range when values are missing

    19 columns wide as of now. Shouldn't grow any wider.
  19. Re: Adding a border to a cell within a table range when values are missing

    Almost perfect. It works but I wonder if I could lose the hardcoded columns in the select statement? Can I read those from a cell on the workbook?

    Thanks for you help.
  20. Re: Adding a border to a cell within a table range when values are missing

    That's great. Many thanks. If I wanted to check only columns 3,4,6,9,12 rather than all, can the loop be modified?

    Thanks again.
  21. [RESOLVED] Adding a border to a cell within a table range when values are missing

    Hello Forum

    I have an Excel table range and I want to flag where data is missing after a user clicks a button to kick off some processing. All I need is a way to identify the offending cell(s) and...
  22. Re: generating a sequence of numbers from a specified value range (1-5 = 1,2,3,4,5)

    Many thanks. I turned it into a function and now it works exactly as I need it.
  23. [RESOLVED] generating a sequence of numbers from a specified value range (1-5 = 1,2,3,4,5)

    Hello Forum

    I would like a function that returns a string of values based on a range of numbers entered into a cell.

    For example, if a user has entered 1,2,3-9,14,17,24,21 then I would like a...
  24. [RESOLVED] Return the column position of found value within a range

    Hi
    I have a named range that sits in range D1 to H1. My program uses the FIND method to check that a value exists in the named range. When the value exists then I want to return the position within...
  25. Re: [RESOLVED] Filter range, copy specific columns and paste to new workbook

    Many thanks - that helped a lot
  26. Re: referencing a workbook and table object from a called function or procedure

    Ah, it's working now. I replaced 'sheet4' with the actual sheet name and now the values is returned. But isn't it better to use the 'internal' name of the sheet in case somebody remains the sheet at...
  27. Re: referencing a workbook and table object from a called function or procedure

    Hello Yowser

    I do pass the 'Thisworkbook' object by reference to the function but when I get an error when the line runs; 9 - subscript out of range. I setup a test to see if the called function...
  28. Re: referencing a workbook and table object from a called function or procedure

    Thanks for your reply Westconn1

    If I am in a function and want to output some values to a table then I need to pass the name of the table + worksheet + column heading into the function so that I...
  29. Re: how can I automate the writing of text value into rows and columns that can vary

    Many thanks for the hint. Code is now working perfectly.
  30. [RESOLVED] referencing a workbook and table object from a called function or procedure

    Hi Forum. Good morning.

    I would like to know how best to reference a workbook and a table object from within a called function or procedure. I have the calling procedure within the worksheet...
  31. Re: Error 1004 (application or object error) : filldown command

    Fixed it.

    I guess it's not possible to use (cells(x,y), cells(a, b) within a range or with the filldown. I just replaced the 2nd CELLS with a resize and the code runs through perfectly.
  32. [RESOLVED] Error 1004 (application or object error) : filldown command

    Hi,

    I have a workbook which is running code and it creates a number of new workbooks. Upon creating a workbook, the code will copy some values to the new workbook onto sheet1 I then want to fill...
  33. Re: Excel 2010 : String comparision : values containing non-uk characters

    Sorry to reply late on this. Been away but wanted to loop back to thanks those who posted a reply or comment. The project went away to the burning issue of the day is no longer keeping me awake at...
  34. [RESOLVED] automate the writing of text value into rows and columns that can vary

    Hi

    I have a workbook that I create from a macro running in another workbook. The macro copies columns to the new (inactive, I guess) workbook into specific columns. So column "A" from the workbook...
  35. Re: Excel 2010 : String comparision : values containing non-uk characters

    Thanks for your reply.

    yes, it is code that I would like. There is a 'pot' of data with 50k row and a list of records that I need to check one-by-one to see if the value appears in the 'pot'.
  36. [RESOLVED] Excel 2010 : String comparision : values containing non-uk characters

    Hi there,

    I need to compare 2 sets of data and flag up where there is either a direct match or a close match. For example, I have a name and a city value in each data set;

    Data Set 1:
    Column A...
  37. [RESOLVED] Enter a value and copy / paste it to all cells in a column where column A has a value

    Hi

    I need to copy a cell value down into all cells in a column where there is a value in column A. So if I enter 'Yes' in cell C2 and there are values in A2 to A300 then I want 'Yes' to be copied...
  38. Re: Returning zip code ranges for a rep

    Superb. Does exactly what I what it to do and very quickly too.

    Many thanks.
  39. Re: Returning zip code ranges for a rep

    many thanks. That is almost meeting my needs 100% except I noticed that I could have a single zip code for a user and the program ignore that in the results. For example;

    1007 223108
    1008 223108...
  40. [RESOLVED] Returning zip code ranges for a rep

    Hi

    I have an Excel workbook with 2 columns (Zip Code and Rep). I want to show the data so that for each rep I can see the range of zip codes. For example.

    This is a sample of data;

    Zip Rep...
Results 1 to 40 of 79
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.