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

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