PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 [128] 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Excel VBA Code HELP - email active sheet plus 1 other
  2. Sleeper: Storing and retreiving text from a separate workbook
  3. [SOLVED:] Delete Blank Columns and Delete Blank Columns
  4. VBA excel access sharepoint slow connection
  5. [SOLVED:] Loop through active columns and save to file
  6. [SOLVED:] Simple syntax problem
  7. [SOLVED:] Deleting all subsequent duplicates below first one in sorted list.
  8. [SOLVED:] Use one cell to create a variable number of rows on a different sheet
  9. using conbo boxes to populate data into text boxes
  10. run time error 91 "object variable or with block variable not set
  11. [SOLVED:] Emailing from Excdel only rows with data showing
  12. macro to remove numbers before first alphabet in a cell
  13. smart vlookup
  14. [SOLVED:] Ofsetting Cell by 1, 0 vba
  15. Search No. & text list
  16. [SOLVED:] Sub-Procedure or Sub-Routine....??
  17. Macro to copy column from multiple files to paste to one file
  18. Function with FOR loop
  19. [SOLVED:] add/insert data validation cell to if column value to left is a number
  20. [SOLVED:] AND and OR formula into an IF
  21. importing specific event log data into workbook
  22. How to copy cells to same place but in another document?
  23. [SOLVED:] Timer please
  24. fullscreen userform
  25. [SOLVED:] Sort current usded range
  26. OCR by MODI via VBA Macro in Excel / Runtime Error -2147417848 (80010108)
  27. Sendkeys not working - trying to copy dated data
  28. Using Record Set in loop
  29. [SOLVED:] combine data from 2 workbooks with matching cells in different locations
  30. Counting files in a folder
  31. Object variable not set
  32. Copy Paste hide columns of Filtered data
  33. [SOLVED:] Creating Functions From Formula
  34. [SOLVED:] Modify code a bit, (combine function)
  35. [SOLVED:] Select certain files with statement (combine files)
  36. [SOLVED:] How to match two filenames?
  37. Subtotal and Label Specific Data Sets
  38. [SOLVED:] need to open file if file exists then merge
  39. [SOLVED:] Minor formatting issue: allow capturing a (.) full-stop as decimal
  40. VBA Copy cells paste +1 column
  41. [SOLVED:] problem with open file Run-time error 1004
  42. [SOLVED:] How to COmbine two files with this code need to modify
  43. [SOLVED:] need help with combine files
  44. [SOLVED:] Change SQL Query Syntax
  45. [SOLVED:] Writing a sub, using arrays, to join information on two worksheets using VBA
  46. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
  47. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
  48. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
  49. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
  50. Transpose Script not copying one specific field
  51. Format user input from inputbox into a lap time
  52. VBA Code to Move row if criteria to tab within same Workbook
  53. Macro to save book with diferent name each time ran
  54. code sequence works manually but not as a macro?
  55. Display VBA assigned values
  56. [SOLVED:] Problem while open file script
  57. [SOLVED:] Change value of a MS Word ActiveX Checkbox
  58. [SOLVED:] Import script help.
  59. [SOLVED:] Excel CF help
  60. multiple comboboxes
  61. [SOLVED:] automatic variable names
  62. Activate Combobox dropdown when cell selected, not when doubleclicking
  63. Add new Row (table)
  64. [SOLVED:] search for the keywords and copy paste to another sheet
  65. HELP... How to copy paste tabs content to another excel in the same order of tabs
  66. Automation help with the current code in VBA excel.
  67. Sleeper: Exit/hide combobox when item in dropdownlist is chosen
  68. [SOLVED:] UF Reflect Sheets & Future Sheets
  69. [SOLVED:] VBA to match data in one file and copy data to an existing file
  70. Run Macro when a character is entered
  71. [SOLVED:] Consolidate a table with keeping 3 column criteria
  72. [SOLVED:] VBA msgBox executing before the previous line of code
  73. Creating user names & passwords to an excel workbook and restricting the view of data
  74. [SOLVED:] How do I automate color coding the highest performers on a chart?
  75. How to bold values that are less than the average?
  76. Combining All Worksheets of all Workbooks into one Workbook
  77. round to even calculation
  78. Combining Rows
  79. Conditional row formatting based on multiple nested IF/AND statements
  80. Assistance with a formula to return values based on time
  81. [SOLVED:] excel UF link to Accesd DB
  82. If Not Like - Checking string for date format
  83. Excel VBA - Hide cell values based on ComboBox selection
  84. Split Worksheet into separate workbooks
  85. Need to transpose data from rows to columns
  86. Userform to check 2 textboxes for duplicate & date check
  87. Possible to create a link/macro to copy cell contents into an intranet page in IE?
  88. [SOLVED:] Colour cell based on dropdown list
  89. [SOLVED:] Vba code to transpose specific range of data from column A to another sheet
  90. [SOLVED:] How to compare data in a spreadsheet and paste matched values in another sheet
  91. Copying data from multiple worksheets to one summary sheet
  92. Filter data based on the date provided by the user
  93. [SOLVED:] [ASK] Excel VBA for multiple files in folder
  94. Option buttons inside frames within a userform disappear partially when scrolling
  95. Button for every sheet one new email
  96. Return query from access to excel combobox
  97. [SOLVED:] Count numbers in a string and add numbers together
  98. Improving VBA code
  99. [SOLVED:] Delete Duplicate Data
  100. [SOLVED:] VLookup with VBA
  101. Highlighting Duplicates in Excel that are not a perfect match
  102. [SOLVED:] Returning a value in the textbox on the form
  103. [SOLVED:] I need a Conditional Formatting formula
  104. VBA code to copy data per month to another sheet
  105. Refresh autofit row using VBA excel
  106. [SOLVED:] [ask]split text with comma to new rows
  107. Pivot Table: VBA code to filter dates based on a date in another cell
  108. Help automating the macro
  109. [SOLVED:] Match first column sheet A with first column sheet B
  110. Having trouble with a VBA double loop iteration
  111. [SOLVED:] VBA To Determine Row label reference values in Pivot Table
  112. [SOLVED:] Remove the Index References table and continue to show the CF
  113. create folder if does not exit
  114. Copy cells in loop
  115. Array (25rows x 6 colomns) to be filled with random numbers with rules
  116. saving pdf file of the specified range
  117. Formula excel Combining to cells
  118. [SOLVED:] Adding range values to email
  119. Excel - Sort data after report refresh and certain cell changes?
  120. [SOLVED:] How to put Cursor in text box and move to next text box?
  121. [SOLVED:] working code inside - need to add a delete the row after the data has been copied
  122. [SOLVED:] VLOOKUP Workbook Reference Asking For Data Updates
  123. [SOLVED:] Network days in VBA Calculation
  124. Selecting dynamic range in Excel VBA
  125. [SOLVED:] Copy a block of lines/rows and paste to another worksheet
  126. Mismatch error
  127. VBA Download File From Link
  128. [SOLVED:] Setting ranges that could change in VBA
  129. Private Sub Worksheet_Calculate() - Not running when workbook opens
  130. Decreasing time by 1 hour
  131. Compare values between 2 tables
  132. Dynamically modify Chart source data?
  133. VBA Macro Summary Sheet
  134. "Subscript out of range" ... Issue
  135. How do I mark my post as 'SOLVED'?
  136. Help with worksheet and workbook objects
  137. loop through cells
  138. Create a dialogue prompt to filter down data?
  139. Run-time error '6': Overflow
  140. Multiple Pivot Generation
  141. [SOLVED:] Exporting Data to .txt - Need Help Setting Directory!
  142. Adding a search box to an Excel sheet using VBA (very novice)
  143. Running Macros in other Spreadsheets
  144. [SOLVED:] Hide rows based on multiple criteria
  145. Specific Sheets Very Hidden
  146. variable counter
  147. boolean variable
  148. When/why does the VBIDE remember/forget its window state/position?
  149. Select Cells based on values in another cell
  150. Combobox from one form filters another combobox in another form
  151. Transfer data from one list box to another in a userform
  152. Add Chart to constantly changing stats table
  153. Day/Time difference VBA
  154. Userform Filter Search
  155. Exel Power View worksheet
  156. [SOLVED:] Is necessary "Set Object = Nothing"
  157. [SOLVED:] Print Array
  158. [SOLVED:] Date value error, need help
  159. [SOLVED:] Help, loop finds overlaps, then adds not overlapped items, but misses the first match
  160. Re-indexing Excel Sheets
  161. [SLEEPER:] Scatterplot Illustration Help
  162. [SOLVED:] Vlookup a text and MsgBox it thanks to VBA
  163. VBA UserForm: Updating Existing Data
  164. 2nd time a freefile is opened, exception is thrown
  165. Saving information from the user form
  166. Run Java code for web page via VBA
  167. [SOLVED:] Preserve line breaks when inserting/pasting into a single Excel cell
  168. [SOLVED:] copy cell value from one workbook to another based on two criterias
  169. [SLEEPER:] Importing all outlook folders to excel using VBA
  170. Pasting a function to be in edit mode in a cell in excel
  171. Multi-Dimensional Array Sort
  172. [SOLVED:] regular expression in excel
  173. [SOLVED:] Go To Previous Worksheet / Go To Next Worksheet {Problem}
  174. change code to incorporate other textboxes
  175. adapting number code to incorporate () - -
  176. [SOLVED:] Make specific text bold in cells
  177. Saving Excel 97-2002 file to Excel 2013 warning about Script Objects
  178. google translator vba code stop working
  179. Converting an Excel macro to run from Word
  180. VBA macro to delete all empty rows and columns
  181. [SOLVED:] Toggle cell value on single click
  182. Challenging VBA Web scraping coding
  183. UDF To Concatenate
  184. Closing a program without killing other workbooks / "Wait please" pop up window
  185. [SOLVED:] filling combobox's issue
  186. Fill Online Application - Acknowlegement number not generated
  187. Delete row with same ID but if found B2B-111 in column C of that ID.
  188. To Trigger an Event based on Certain Time and Certain Date
  189. [SOLVED:] How To Write A Macro To Compare Active Row With Specific Columns In Above Row
  190. Colour pattern matching
  191. Hire Help
  192. [SOLVED:] VBA FollowHyperlink
  193. userform not behaving properly
  194. Tidy up old verbose coding
  195. [SOLVED:] Worksheet change code
  196. [SOLVED:] Add password to togglebutton code?
  197. How to Optimize 6 nested loop coding in VBA.
  198. ListBox size issue
  199. Save As button using VBA Code
  200. [SOLVED:] Preventing VBA converting cell value to date when printing as .txt
  201. VBA:comboboxes to present same date in different formats...ADAPT WITH CHANGE IN DATE
  202. [SOLVED:] Simple Date to Text Conversion
  203. Download files from URL, unknown file names
  204. Need to match every reference in sheet 2 column A for a match in Sheet 1 Column A
  205. 3DES encryption using VBA
  206. [SOLVED:] Transpose Nested Data
  207. [SOLVED:] HELP -- Hyperlink Question
  208. Prevent user edits to a workbook without making the workbook dirty
  209. [SOLVED:] help needed with Vlookup and IF function
  210. [SOLVED:] Else without If statement compiling error
  211. [SOLVED:] Method 'Open of object 'Workbooks'Failed
  212. Auto fill Cells Down if other cells have information
  213. [SOLVED:] Running multiple VBA functions within one sub
  214. GPIB to USB Controller
  215. Quick VBA Rows Question
  216. How to concatenate ComboBox name
  217. VBA old test question help
  218. VBA to override all upcoming code for certain users??
  219. Help switching between two images
  220. Import MS Project to Excel 2000
  221. Delete row based on 3 conditions
  222. [SLEEPER:] Help Calculating averages based on options selected in user form
  223. Using worksheet function randbetween for non-contiguous number ranges
  224. Use SaveAs to create new workbook
  225. Help with Importing Part of a text readable file into Excel worksheet via Macro
  226. Use ShellExecute to do a programmatic string search in an opened PDF file
  227. [SOLVED:] Using VBA to rename files - from Auotgenerated microscope to multiple array location.
  228. [SOLVED:] catching malformed data before sub runs
  229. Putting a Variable into a formula
  230. [SOLVED:] Extracting data in "Treeview" from web using VBA
  231. How to email a pivot table using VBA
  232. [SOLVED:] Macro to update columns depending on row identifier
  233. [SOLVED:] Software Library from .nessus files
  234. Lock Cells after date passed - VBA Code
  235. MACRO or VBA Required
  236. [SOLVED:] My filter by Invoice number skipping part of code
  237. How to catch the duplicate number in excel
  238. Vlookup in vba for dynamic range on data
  239. Userform Help - Adding more than one record.
  240. Audit Log - track changes to all cells in a workbook
  241. Model cell colours
  242. Need a formula to show the cell coordinates
  243. Copy random numbers and sort.
  244. VBA to do something 5 times then go back
  245. Need some help pls. How to color cell A if cell B is an even number
  246. Loop through worksheet and create a new column based on cell values in another column
  247. Extract string from multiple files using vba
  248. Need help with homework problem
  249. Need help with this review problem
  250. [SOLVED:] Store individual cell contents in arrays, match terms and highlight when found