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

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