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

  1. Solved: Excel 2003 and 2007 - Cannot make selection in Listbox2 if click Button twice
  2. Variables declared with 'New' cannot be made Nothing!
  3. Solved: Restrict Text Box
  4. Pastespecial xlvalues
  5. Couple days of work - now lost
  6. user form textbox issue
  7. Solved: For Next Loop not completing
  8. [SOLVED] Building Tables from List
  9. Solved: Using Vlookup On UserForm
  10. sorted data
  11. Solved: Formula results are different then Pivot Table
  12. Solved: VBA Assigning Variable / Runtime Error 1004
  13. Solved: Supressing '#N/A' in WorksheetFunction.VLookup
  14. tab colour
  15. Combinations
  16. ANNIVERSARY DATE
  17. Solved: Sales forecast
  18. Check box control on a worksheet
  19. Solved: cell.adress question
  20. Solved: number format 0.00 /m
  21. Macro to do logic based on other column
  22. Solved: .FormulaR1C1 = "=" & Formula_A
  23. Solved: copy paste doesn't work
  24. Solved: TextBox: Entering Date in specific format
  25. Excel VBA. Calculating worktime with different overtimes
  26. Solved: Optionbutton deselection erases range value
  27. Solved: Copy/Paste All Cells on a Non-active worksheet
  28. Need a reference on where I can hire a local vba Excel expert to work on a project
  29. how to remove some range of cell only,
  30. Further variation of Index/Match
  31. Toolbare with option
  32. Solved: Concatenate If in an Array
  33. Custome objects and Collections Classes. Help Please!!!
  34. Selecting a range of sheets using crit in my Criteria
  35. Solved: Printing Problem
  36. Macro help - "Force Use Macros" plus "Auto Close"
  37. Strange formula - now sure how it works
  38. Automatic Cut/Paste to new sheet at every month end
  39. Solved: Trouble Storing Worksheet in a Variable
  40. Solved: Rounding in units of 0.5
  41. Error handling: #REF!
  42. do not display hide worksheets in data validation list
  43. Solved: Array Formula not recognizing Imported Data as a Number
  44. Solved: Validation data - excluded from list
  45. Solved: VBA - Value Copy Multiple Criteria
  46. Noob with a (probably) simple one
  47. Find problem
  48. Solved: Question on Hpyerlink
  49. cells colour
  50. Consolidating multiple sheets onto one "parent" report sheet.
  51. Adding a chart
  52. Excel Chart Object Name
  53. Solved: display msgbox once
  54. Edit objects
  55. Delete rows when the code gets deleted.
  56. checking string in IF Loop
  57. VBA for combo box
  58. Is it possible to write vba code to create a conditional format on cells?
  59. "FindNext" function
  60. Solved: Using Excel To Send Emails Through Lotus Notes
  61. Retrieving Data from another Worksheet
  62. Solved: Login Prompt
  63. Solved: Positioning UserForms
  64. Solved: TRIM in VBA
  65. Solved: Is it Vlookup or Sum Product ?
  66. Excel + Access Help
  67. Solved: need dynamic range
  68. option button macro
  69. Solved: Need to loop thru a folder of workbooks and extract customer addresses
  70. comparing the 2 excel
  71. Solved: Enter the next consecutive number
  72. Listbox active workbooks and copy data
  73. using Excel function TRIM rather than VBA function TRIM
  74. Clear contents in the last populated cell
  75. email different sheets to different people - code needs changing
  76. Is it possible to transfer data from ms access to excel using vba code?
  77. Solved: Conditional Formatting only when value is present
  78. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value
  79. Solved: Loop through controls and add data from cells
  80. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003
  81. Solved: Make sure numbers are increasing
  82. Navigating Through a Recordset (Adding a Record Counter)
  83. Create 1 Public Sub for 5 textboxes
  84. Solved: POP UP Message when a criteria is met
  85. Menu tree
  86. Formatting a column into "text"
  87. data model in excel
  88. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one
  89. Using iMacros in a loop with input from Excel
  90. Solved: how do i get the the name of the user who opened the file?
  91. Using vba to open website
  92. Solved: Locate values from List
  93. Extract rows to new worksheet and save as new workbook
  94. Excel Problem
  95. Solved: Selection Rows CountA?
  96. Solved: Code not updating all worksheets
  97. SSN Format
  98. Update code in 220 objects
  99. SUM IF in vba and result in message box
  100. Solved: Problem with copy/paste "Formats"
  101. Using Yes No Message Box
  102. Excel 64bit issue with Winsock UDP connection
  103. Automatic Macro execution
  104. Insert Hyperlink from External Source to a Protected Sheet
  105. VBA Chart fill area
  106. Excel 2003 VBA coding and "pop up button" help
  107. Excel 2003 VBA coding tweak
  108. Read external data from dynamic text range, then calculate stats
  109. Solved: Two listboxes on same userform problem
  110. File (path to a folder) not found
  111. creating a data base using Excel & VBA
  112. Print workbook - disable
  113. How do I close an instance of Quickbooks in VBA?
  114. Sum Values in defined target
  115. Solved: need a magic formula to ..
  116. Write data to sheet 2 if sheet 1 is full
  117. "Window" menu item
  118. VBA Help needed total newbie
  119. DOM: Searching only the tags embedded within one particular div tag
  120. Macro help required if possible
  121. Excel keeps switching between 'ready' and 'chart updating'
  122. Solved: Clear Red Interior if Text is Red
  123. excel addin problem
  124. count the no. of A
  125. VBA Copy & Paste
  126. Excel 2007/2010 - Can I have workbook specific disabling of row inserting?
  127. System Error: &H8001010D (-2147417843) An outgoing call cannot be executed...
  128. VBA code below
  129. Filter Sheet With text on cell
  130. VBA array difficulty
  131. Is it possible to use vba to automate a count on recurring data?
  132. Solved: Input Box Validation please help
  133. Solved: Find maximum value in a column
  134. Excel stopwatch needed
  135. max value of another textbox
  136. Open web Page and clink on a link within the page
  137. Set Cell Value As Variable?
  138. How to turn any URL input into file name
  139. pervent only one sheet from deletion
  140. Sumif
  141. Creating charts using VBA: problem with intervals
  142. Report from excel database ??
  143. Ado DB connection in Excel
  144. Solved: Create new folder with name and date
  145. Solved: VBComponents - how to retrieve "Sub" or "Function" exactly
  146. Need help with default save script from 2010 to 2003
  147. Return control after application.run
  148. Solved: Split cell contents into multiple rows
  149. Solved: Selecting a Rows with Data
  150. using conditional formatting
  151. Solved: Mortgage loan spreadsheet problem
  152. Finding special charecters in excel
  153. formula for logical condition
  154. Solved: Code prevents formulas working!
  155. Solved: Merge Workbooks
  156. Sending Excel Cell Data via E-Mail
  157. Solved: Why does code need On Error Resume Next?
  158. SaveAs Command to Overwrites a Excel File
  159. Detecting a cell change
  160. Data Input Form Workbook
  161. How to select option in pop-up list????
  162. excel VBA and post for ASP.NET
  163. Solved: display multiple labels as $0.00
  164. Solved: use input box chara to create new woorksheet name
  165. Run-time error '13' on comparing arrays help needed
  166. Is it possible to upgrade Excel and perform File Remediation using vba?
  167. clear contents formula
  168. Solved: Ignore Countif If Cell Contains a Value
  169. Solved: Disable all saving
  170. Is that possible to excute code by using Keboards "CTRl+Eneter"
  171. Highlight The Selected.
  172. VBA code-Signature code failure
  173. Cut and paste the challenge
  174. Error using Find function
  175. Solved: Insert row above next empty cell within a column
  176. Solved: Question About copy Selection
  177. Basic question about Application.enableevents
  178. highlight the cell with "peter"
  179. Solved: Excel - Change font color if invoice number is out of order.
  180. Solved: disable protected sheet message
  181. Problem switching between Excel and Word
  182. Input Mask
  183. UDF to calculate average according to condition, ignoring blanks
  184. Solved: Specific cell selection
  185. Compile Error
  186. Update only the latest data from Excel to Access table
  187. Extract data from PDF
  188. VBA Select Case
  189. Help with clear contents
  190. Is there a formula or statement that works out percentage rates in Excel?
  191. Solved: Search for text in IE
  192. Last row of the worksheet
  193. Solved: How to print from sheet active to the another sheet
  194. Loop the code
  195. Worksheet Delete
  196. Transpose single column array
  197. Solved: Stop CommandButton moving or rename button
  198. Solved:
  199. Request for review
  200. Solved: Select Row problem
  201. Help defining and setting variables
  202. Permutations
  203. Solved: Decrease qty thru msgbox
  204. Loop Help
  205. VBA to export 2 worksheets at a time
  206. For loop trouble
  207. Printing Copies with VBA
  208. Solved: Only copy selected sheets
  209. VBA code to run on specified time
  210. Solved: Nested IFs
  211. Solved: Directory Path
  212. VBA match, copy , paste and append
  213. Solved: need to contain clearing of row within a range
  214. Solved: Spinbutton and date textbox
  215. Mortgage spreadsheet concept problem
  216. Action when result of formula changed
  217. Solved: Help with loop please
  218. Solved: Columns to Rows keeping data integrity
  219. Solved: userform label format
  220. Solved: Macro to go to first worksheet in any workbook
  221. Solved: Delete after first space
  222. Copy Data to the Serial Number Row
  223. Solved: Simple Formatting
  224. Solved: spinbutton on date textbox
  225. Inserting an image based on the option choosen
  226. Disabling multiple textboxes
  227. Label Calculation
  228. Solved: .text to .value
  229. Solved: Finding text on ie that's next to what you search
  230. Timed VBA Mail code
  231. Solved: Set the Data / Group and Outline / settings..
  232. Cannot get the protection code to work with the rest
  233. Excel workbook "access denied"
  234. Delete the repeated code
  235. Office 2003 Combobox_Enter
  236. Solved: Disable Form Control Button/Code
  237. Solved: The Art of Conditional Formatting!
  238. Solved: Text to columns (With only the first bit of text)
  239. Solved: Create and Edit a Scheduled Task from Excel
  240. Solved: Check the clipboard for Data before paste?
  241. Comparing values from Different worksheets
  242. Need to preventt xlsm file from being converted to xls
  243. Dynamic chart-Modify series formula from vba
  244. Multi sheet macros.
  245. Solved: calculate difference between 2 excel files
  246. Solved: VLOOKUP multiple criteria
  247. Business Days
  248. Modify code to also remove cell borders
  249. Disable Fn Alt and Ctrl Keys
  250. vba password recovery