User Profile

Collapse

Profile Sidebar

Collapse
nabusafe
nabusafe
Last Activity: Sep 13 '18, 07:39 PM
Joined: Sep 7 '18
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nabusafe
    started a topic Revise Code to Append Expanded Numbers Properly
    in Visual Basic

    Revise Code to Append Expanded Numbers Properly

    So I'm having an issue with my current code.

    Code:
     Sub ExpandRanges()

Dim X As Long, CG As Variant, Rng As Range, Cell As Range
Dim Series As String, CommaGroups() As String, DashGroups() As String
Dim j As Long, lastrow As Long

j = 0
lastrow = Cells(Rows.Count, "H").End(xlUp).Row

Set Rng = Range(Range("H2"), Range("H" & lastrow))
    ...
    See more | Go to post
    • nabusafe
      replied to Expand Range of Numbers with SQL in Access
      in Access
      Thank you guys both for your help. I really appreciate it.

      I will be honest I'm not very proficient with VBA so all of this code is kind of confusing.

      Is there anyway someone could attach a downloadable file that shows how all of this code is ran and executed? I would truly be grateful
      See more | Go to post

        Leave a comment:

      • nabusafe
        replied to Expand Range of Numbers with SQL in Access
        in Access
        Thank you so much for your response!
        However I am a bit confused, where am I entering this code and what exactly will it do for me? Sorry for the confusion!
        See more | Go to post

          Leave a comment:

        • nabusafe
          started a topic Expand Range of Numbers with SQL in Access
          in Access

          Expand Range of Numbers with SQL in Access

          Hello.

          So, I am a logistics engineer and I am trying to help my pricing manager build a pricing application tool that will help eliminate her time spent filling in huge excel files with information about pricing bids. I have successfully build an Access form that fills in the areas she wanted filled in but I come across a new problem now:

          Every once in a while she will receive an RFP (Request for Proposal) which has...
          See more | Go to post
          No activity results to display
          Show More
          Working...